All Forums Database
BaldTony 6 posts Joined 03/06
17 Mar 2006
How can I spot strings that are in UPPER case?

Is there a way to tell whether or not a string value is in upper case?Intuitively you tend to think along the lines of testing UPPER() = but that doesn’t work because Teradata (at least, our installation of Teradata) is not case specific in its searches or comparisons.Trying > or < instead of = doesn’t work for the same reason.TIA.

dnoeth 4628 posts Joined 11/04
17 Mar 2006

select *from tabwhere col (casespecific) = upper(col)orwhere col (cs) = upper(col)Dieter

Dieter

BaldTony 6 posts Joined 03/06
17 Mar 2006

Supreme Being Deiter, I am in your debt. Worked a treat.Many Thanks.

You must sign in to leave a comment.