+ Reply to Thread
Results 1 to 3 of 3

SQL query for upper-case in field?

  1. SQL query for upper-case in field?

    Hi,

    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?

    Thanks,
    Jim


  2. 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.

  3. Re: SQL query for upper-case in field?



    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


+ Reply to Thread