Not sure about firebird, but you would usually use like or mathes. Where field like "%hi%" Where field matches "%hi%"
Stacey -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David O'Brien Sent: Friday, 10 March 2006 16:28 To: 'NZ Borland Developers Group - Delphi List' Subject: [DUG] Firebird SQL 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. _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
