Hi!

Thank you for the lighting fast answer. I would happy with exact match
because

WHERE LANG1='something' could be very different.
I doesn't know the form of searched string...
It may be like:
something
something...
~something
some~thing
so~mething...

So I don't know how to do the match. In my opinion if I remove ~ and ... from LANG1 (also pre/post spaces and whitespaces) I will get a better match. I think I should use procedure and call it like:
SELECT STRIPUNNECESSARYCHARS(LANG1) AS STRIPED, LANG2 FROM TRANSLAT WHERE STRIPED='something';

Can you help me?

Thanks,
KAMI

Svein Erling Tysvær írta:

>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?
>>
>>
>
>
>
>