hello everyone,

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
Tel: +34 932 607 787