Hello John,

JJk> I get NULL as result

>> On Sat, 7 May 2005 22:20:04 +0200, John Jaab?k <johnjaab@...> wrote:
>> > Well, try this and see what kind of result you get:
>> >
>> > Select * from your_table where your_field Like '%hydro';
>> >
>> > Select * from your_table where your_field Like '%hydro%';
>> >
>> > Select * from your_table where your_field Like 'hydro%';

Note that LIKE is case-sensitive, and CONTAINING is case-insensitive.
Since you have 'Hydro...' as your data, and search for LIKE 'hydro%',
you have no results (correct).
And refer to Aage's advice on specifying (charset and) collation for
strings, which embedded into SQLs, for example
_ISO8859_1 'you string, probably with Scandinavian letters' collation NO_NO


HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com