Archives of the TeradataForum

Message Posted: Thu, 11 Sep 2003 @ 19:30:05 GMT


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

Tom Ruffner wrote:

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.

That's why i added (cs) in my query ;-)

WHERE UPPER(col) = LOWER(col) (cs)

Dieter


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

Archives

2003 Indexes

Last Modified: 15 Jun 2023