Archives of the TeradataForum

Message Posted: Thu, 11 Sep 2003 @ 15:47:32 GMT

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

Be careful using

When UPPER(col) = LOWER(col)

Because we load data from many different sources we define character columns as:

NOT CASESPECIFIC

so When UPPER(col) = LOWER(col) returns alpha characters as well as numeric.

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