Case sensitive problem

• _ms65g_

  SSCommitted

  Points: 1504

  More actions

  August 1, 2010 at 12:18 am

  #225632

  Hi, I need to compare a two string in case sensitive mode but even I use a proper collation but the result is incorrect. Which collation will help me?

  select PATINDEX('%[a-z]%', 'A12123z' collate SQL_Latin1_General_CP1_CS_AS)

  --> Correct!

  select PATINDEX('%[A-Z]%', 'sdfasCdfsfA' collate Latin1_General_CS_AS )

  --> Incorrect! the result is 1 but correct one is 6

• sumit.agrawal

  SSCommitted

  Points: 1616

  More actions

  August 1, 2010 at 9:48 am

  #1200763

  U can use Binary collation.... SQL_Latin1_General_Cp850_BIN