Subject Re: [ib-support] wildcard characters
Author Martijn Tonies

WHERE my_column like '%example%'

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

Upscene Productions

"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