Hi Kami!

One similar thing you can do (though it isn't exactly what you ask
for), is

SELECT LANG1, LANG2 FROM TRANSLAT
WHERE LANG1 CONTAINING 'Check' AND
LANG1 CONTAINING 'this'

I don't know how to make sure 'Check' is before 'this' or to ascertain
that there are only spaces and special characters between the two
words. Moreover, partial match of words are also returned (e.g.
CONTAINING 'check' will also match 'unchecked').

HTH,
Set

--- In firebird-support@yahoogroups.com, KamiHír wrote:
> Hello!
> I have got a basic query like:
> SELECT LANG1, LANG2 FROM TRANSLAT WHERE LANG1='"Check this';
> The database may contains thgis form of sttring
> Check ~this
> ~Check this...
>
> How can I remove whitespace, space, dot and tide characters from
> results to match with LANG1='"Check this' where condition?