[DUG] Firebird SQL

[Stacey Verner]

Not sure about firebird, but you would usually use like or mathes.

Where field like "%hi%"
Where field matches "%hi%"

Stacey

-----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 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
Delphi at ns3.123.co.nz
http://ns3.123.co.nz/mailman/listinfo/delphi