[DUG] Firebird SQL

[Richard Vowles]

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: richard.vowles at borland.com
phone: +64-9-9184573
cell: +64-21-467747
other: MSN richard.vowles at borland.com, skype: rvowles

-----Original Message-----
From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz]
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
Delphi at ns3.123.co.nz
http://ns3.123.co.nz/mailman/listinfo/delphi