Archives of the TeradataForum
Message Posted: Thu, 10 Mar 2005 @ 18:18:26 GMT
Subj: | | Re: Distinguish chracters from intergers |
|
From: | | Victor Sokovin |
Where CASE WHEN UPPER(STRNG) (CS) = LOWER(STRNG) (CS)
THEN 1 ELSE 0 END = 0
| You can add this in your where clause... It will filter out the char values leaving numbers behind. | |
I am sorry for nitpicking but this clause won't filter out *all* the chars as I tried to demonstrate in a few threads on this forum. If you
have non-ASCII chars in your DB, please refer to the thread in my previous posting. It shows an example of the char which the filter will let
through. There are many more examples of this kind.
Victor
|