Does the "in" operator work in Firebird? i.e. Select * from table where 'hi' in field. If not, how should I go about selecting data from partial matches? Dave.