LIKE clause with matching case

• Charles White-432278

  Newbie

  Points: 1

  More actions

  May 7, 2007 at 6:01 pm

  #172357

  Hi,

  does anybody know how I can build a WHERE field LIKE'a%' clause

  that will not return A.

  ie a WHERE clause that is case sensitive. I don't want to really

  change any collation or anything like that. I was wondering if there

  was an escape sequence or similar.

  I have heard that I need to do a CAST or CONVERT to binary and then

  compare the binary? How would this work?

  Thanks

  Charlie

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  May 7, 2007 at 8:46 pm

  #704818

  you can still use a collate function in your where clause without Changing your table definitions.

  SELECT    mycolumn

  FROM      mytable

  WHERE     mycolumn COLLATE Latin1_General_CS_AS like  'a%'

  that is about the cleanest way to do it.