Archives of the TeradataForum
Message Posted: Thu, 25 Sep 2003 @ 13:19:15 GMT
| Subj: | | Re: Soundex() and Latin Letters |
| |
| From: | | David Clough |
John Mansfield writes ...
| | 1) How do I detect these 'Non-Latin' Characters and then | |
| | 2) How do I remove them from the string or better yet, | |
| | 3) how do I get the best use of soundex() | |
1) I recently had a play with this :
... CASE WHEN TRANSLATE_CHK(NAD_ADDR_1_DS USING Latin_TO_Unicode) > 0 THEN
' ' ELSE NAD_ADDR_1_DS END AS NAD_ADDR_1_DS_OK
In my construct the whole of the address would be blanked out if it contains any Latin characters, but you could of course do
it character by character.
Whether choosing unicode was the best check against non-Latin characters I couldn't say, but it worked for me.
2) This allowed me to then go forward and strip-out non-alphanumeric characters from NAD_ADDR_1_DS_OK (using a technique similar to that
which has been suggested a few times on the Forum. If you'd like my method then I'll gladly send it to you).
3) God knows, I can't see much use for it and I've asked similar questions myself.
Dave Clough
Database Designer
Database Design Group
| 
