Archives of the TeradataForum
Message Posted: Wed, 07 Dec 2005 @ 16:16:26 GMT
| Subj: | | Re: Check Values is Numeric? |
| |
| From: | | Victor Sokovin |
| | If only alphabets are present, you can use UPPER and CASESPECIFIC functions and check. | |
This works only for ASCII characters. Even within the Latin character set in Teradata one can find a dozen or so characters for which lower
case would be the same as the upper case.
I think the simplest way to detect numeric values is to do string comparison. In Latin (and standard collation rules) the test string could be
just 'A', for example. One might also think about filtering out special characters with lower ASCII values except decimal dots or commas.
The "standard" recommendation nowadays seems to be to go use a User Defined Function (UDF) but then again you don't give such an advice to
somebody who posts a question like this one, do you? It's like driving past a hitchhiker and shouting: "Get a car!"
Regards,
Victor
| 
