Archives of the TeradataForum

Message Posted: Thu, 10 Mar 2005 @ 16:34:42 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

..kiki..

Kiki Sanchez
Data Warehouse Group
Technology Division
Continental Airlines

	<Prev	Next>		<<First	<Prev	Next>	Last>>