Finding Records without A-Z 1

[campbere]

I am trying to find all the records for a column that does not have all capital letters, ABCDEFGHIJKLMNOPQRSTUVWXYZ. I tried the following:

Select widget_column
from widget_table
where widget_column not like '%ABCDEFGHIJKLMNOPQRSTUVWXYZ%'

However I still got records back that had all capital letters like:

WIDGETPRODUCT

Can someone help?

So I want to identify records like:

Widgetproduct
Widget(product)
WidgétPRODUCT

 

[sem]

The query you use returns all records that doesn't contain substring 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', and this is obviously no what you need. Try

where ltrim(widget_column,'ABCDEFGHIJKLMNOPQRSTUVWXYZ') is not NULL

This should return all values not consisting of uppercase letters only.

Regards, Dima

http://seminihin.narod.ru

 

[carp]

Or you could try

WHERE widget_column != upper(widget_column)

Elbert, CO
1202 MST