>> You have to write >> "SELECT returnField FROM Tablename WHERE textfield LIKE 'two' no_case" > > > But this will find "Macintwosh", too ;-) > And that's something I don't want! > If you want to find ONLY the word 'two' then you can write LIKE '\btwo\b' no_case. Hans