Sure does
Although the syntax isn't what you are showing below. It is the
following...
SELECT * FROM Table WHERE Field IN (VAL1, VAL2....);
However if you are after partial matches you actually want
SELECT * FROM Table WHERE Field LIKE '%hi%';
The % is the wild card. You can also do a containing which is case
insensitive.
SELECT * FROM Table WHERE Field CONTAINING 'hi';
Hope that helps.
Rob Martin
Software Engineer
phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd
David O'Brien wrote:
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
