Archives of the TeradataForum
Message Posted: Thu, 10 Mar 2005 @ 16:34:42 GMT
This is a trick that a co-worker of mine gave me.
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 have never tried it in a where (only in the select part), but it should work.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|