Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    26

    Unanswered: checking for uppercase in a query

    hi,

    how do you find all records that are in uppercase a query

    eg.

    A.name contains ('tom','Bill','MARY')

    select * from A where A.name is only uppercase

    will return

    MARY

    thanks

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Perhaps this?

    SELECT * FROM a
    WHERE a.name = UPPER(a.name);

Posting Permissions

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