Upper/Lower case in my data...odd request

• krypto69

  SSChampion

  Points: 13604

  More actions

  May 11, 2010 at 12:56 pm

  #222372

  I had an odd request from a user..

  They are having an issue with the app where it is inserting lower case letters (into a varchar) by mistake..so they now need the ability to tell in a query which of the words are lower case and which are upper case..

  I don't know if I explained that well....basically the word is 'Print' or "print' they need to know how many times it was entered into the field as 'Print' or 'print'.

  How can I tell that in T-SQL?

  select stmt_del_method, *

  from rm_acct

  ---

  where stmt_del_method = 'Print'

• krypto69

  SSChampion

  Points: 13604

  More actions

  May 11, 2010 at 1:11 pm

  #1165782

  I think I answered my own question...

  select stmt_del_method, *

  from rm_acct

  ---

  where stmt_del_method = 'Print' COLLATE Latin1_General_CS_AS

  --where rim_no = '1402809'

  order by stmt_del_method