Query To Find Lower Case Letters In A Column

[Scott Krise]

Hello,

I wrote a query that I thought was simple...but its proving not to be. All Im trying to do is find all the records that contain at least 1 lower case letter.

So, I thought something like this would work:

SELECT * FROM in_master i where upper(upc) <> upc

But, it doesn't. I saw something on-line where you could use the COLLATE in your query...but that didnt seem to work either.

Anyone know what I'm missing?

Thanks,

Scott