 |
 |
Archives of the TeradataForum
Message Posted: Mon, 15 Sep 2003 @ 19:04:07 GMT
| Subj: | | Re: Soundex() and Latin Letters |
| |
| From: | | Watzke, Michael |
John:
| | 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.
Mike
| |
