The IN operator is defined as an exact match in SQL. Partial matches would use '%value%' or the key word "containing" which works with blobs and text fields and is case insensitive.
At least in InterBase. Richard (Moving to 'DevCo') --- Richard Vowles, Solutions Architect, Borland New Zealand email: [EMAIL PROTECTED] phone: +64-9-9184573 cell: +64-21-467747 other: MSN [EMAIL PROTECTED], skype: rvowles -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David O'Brien Sent: Friday, 10 March 2006 4:28 p.m. 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
