Re: SQL query for upper-case in field?
From: ohaya <ohaya_at_cox.net>
Date: Wed, 26 Mar 2008 12:58:50 -0400
Message-ID: <dhvGj.45141$f8.2618@newsfe23.lga>
>>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?
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.
C.,
A GREAT BIG THANKS for the quick reply!!
Jim Received on Wed Mar 26 2008 - 11:58:50 CDT