Hi,

WHERE my_column like '%example%'

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> could someone tell me which is the wild card character in interbase for
> searching a substring in a column of a table? I would like to do something
> like this:
>
> SELECT * FROM my_table
> WHERE my_column LIKE "*example*"
>
> The '*' mean that we want to get all the rows which have the substring
> "example" in any position in the column "my_column" (eg: "my example",
> "example 1", "my example ok", or just "example").
>
> Thanks.
>
> Xavier Solé.
>
> --
> Xavier Solé Acha (mailto:x.sole@...)
> Servei d'Epìdemiologia i Registre del Càncer
> Institut Català d'Oncologia
> Av. Gran Via km. 2,7
> 08907 L'Hospitalet de Llobregat, Barcelona
> Tel: +34 932 607 401