4 Replies Latest reply: Feb 15, 2013 3:56 AM by Chanchal Wankhade RSS

    Search for upper/lower case characters in order?

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