Archives of the TeradataForum
Message Posted: Mon, 15 Sep 2003 @ 19:04:07 GMT
| Subj: || || Re: Soundex() and Latin Letters |
| From: || || Watzke, Michael |
| ||1) How do I detect these 'Non-Latin' Characters|| |
The error specifically means the characters are not a-z or A-Z, not non Latin. So numerics and punctuation will cause this error.
| ||2) How do I remove them from the string or better yet,|| |
| ||3) how do I get the best use of soundex()|| |
Probably the best thing to do is to ignore these non alpha characters when calculating the soundex code, I believe this is what the US
census soundex generator does.
Unfortunately I don't know of a simple way to preprocess the string within a DML statement with current Teradata functions.