Re: Query To Find Lower Case Letters In A Column

[Scott Krise]

I've tried the following with no luck...

SELECT upc FROM in_master i where upc regexp '[a-z]'
SELECT upc FROM in_master i where upc regexp '[*a-z]'
SELECT upc FROM in_master i where upc regexp '[*abcdefghijklmnopqrstuvwxyz*]'

All of these return both upper and lower case letters.

The only thing I found that started to get me what I wanted was...

SELECT part_number, upc FROM in_master i where upc regexp '^[^ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890-]'

but this one only returned the UPC where something other than the characters in the in the list are the first character. Still seems to ignore ones where the first character is lower case.

All examples appear to consider upper and lower case letters to be the same.