At 09:33 AM 12-09-02 +0200, you wrote:

>Hi all,
>how can I let my customer search in a specified field for any string
>within a string
>
>eg : he want to search for 'stre' in the streetname of an address, he
>selects the column with the streets en the program must return all the
>record who meets the searchcriteria
> ==> Waterstreet
> ==> street of george
> ==> ...
>
>Thanks for the answer

WHERE MyStringField CONTAINING 'stre'

or, if you want it to be case-insensitive:

WHERE UPPER(MyStringField) CONTAINING 'STRE'

If MyStringField is indexed, then the case-sensitive search will use the
index (=fast). The case-insensitive search using UPPER() cannot use the
index (=slow).

To get the best of both, define a trigger-populated column that stores
UPPER(MyStringField) and place your index on that...

Helen