Re: SQL query for upper-case in field?

From: ohaya <>
Date: Wed, 26 Mar 2008 12:58:50 -0400
Message-ID: <dhvGj.45141$f8.2618@newsfe23.lga>

codadilupo wrote:

> ohaya wrote:

>>We have a table named "user", and want to determine how many records in
>>the table have one or more upper-case characters in the "name" field.
>>I've searched, and find lots of examples like converting a field's
>>contents to upper-case, but in our case (sorry :)), we just need to
>>determine how many records already have upper-case in that field.
>>Is it possible to do this with Oracle SQL, and if so, could someone give
>>me an example of an SQL query that would do this?
> select count(*) from users where name!=lower(name);
> C.


A GREAT BIG THANKS for the quick reply!!

Jim Received on Wed Mar 26 2008 - 11:58:50 CDT

Original text of this message