Re: SQL query for upper-case in field?

From: codadilupo <>
Date: Wed, 26 Mar 2008 14:48:57 +0100
Message-ID: <47ea5449$0$31746$>

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. Received on Wed Mar 26 2008 - 08:48:57 CDT

Original text of this message