Subject | Remove selected chars from results' field |
---|---|
Author | KamiHĂr |
Post date | 2005-05-14T20:36:05Z |
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?
Thanks,
KAMI
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?
Thanks,
KAMI