[DUG] Firebird SQL

[Robert martin]

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