Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    1,074

    Unanswered: Finding lowercase entries

    An OracleForm edit has not been catching entries into the system in mixed-case (it should all be converted to uppercase).

    Is there a query I can run against the db which will find mixed-case entries in a field?

    Thanks,
    Chuck

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Code:
    SELECT * 
    FROM yourTable
    WHERE yourColumn <> upper(yourColumn)

  3. #3
    Join Date
    Dec 2003
    Posts
    1,074
    Why did I think it had to be so complex?

    I did find this:
    Code:
    select * from (
    select 'UPPER' field1 from dual
    union all
    select 'MiXeD' from dual
    union all 
    select 'lower' from dual
    union all
    select 'SPECIAL !@#$%^&*() CHARACTERS' from dual) dataset
    where regexp_like (field1, '([a-z])', 'c')
    -------
    MiXeD
    lower

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •