CASE matching

• Noman Tariq

  SSCommitted

  Points: 1750

  More actions

  April 1, 2006 at 10:04 am

  #171820

  Hi all,

  I have a problem, pelese guide me I want the exact matching between the letters:

  e.g.,

  select user_name, password

  from tbl

  where password = 'ABCDEF'

  ---------------

  in DB i have 'abcdef' not in caps. but it will give me the user name as well.

  I want matching the case as well.

  Please guide me.

   

  Noman

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  April 1, 2006 at 11:39 am

  #630283

  This is how I'd do it in SQL2K...

  If all you wanted was to convert the db colum to uppercase you'd compare..

  where password = upper(colPwd)

  If you wanted to match the case between user input and db column and your db is default case insensitive you could use "collate"...

  where password = colPwd collate Latin1_General_CS_AI

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**