Re: SQL query for upper-case in field?

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