Hi Xavier,

You can use:
SELECT * FROM my_table WHERE my_column LIKE '%example%'

or use the word CONTAINING:

SELECT * FROM my_table WHERE my_column CONTAINING 'example'

I believe you can change the wildcard character too, but I don't remember
how.

Anyone know how to do that?

Rick

> 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é.