4 Replies Latest reply on Feb 15, 2013 9:56 AM by Chanchal Wankhade

    Search for upper/lower case characters in order?

    Dorbs
      Hello,

      In our user table, system generated logons are all upper case, however manually created users (which is what I need to search for) Start with 2 upper case characters followed by the rest lower.

      What would be the correct way to search for this, for example bring back all results where user_name has 2 upper case characters followed by lower case?

      Many thanks and hope you can help.