PATINDEX bug?

• kung lao

  SSC Veteran

  Points: 296

  More actions

  July 24, 2007 at 9:45 am

  #196995

  This is really wierd and I hope someone can shed some light -

  Why does doing this pattern search hit on the lower case 'a'?

  SELECT PATINDEX ('%[¾-À]%', 'abcdefghijk')

  Same this as doing:

  declare @Pattern varchar(250)

  set @Pattern = '%['+char(190)+'-'+char(192)+']%'

  SELECT PATINDEX (@Pattern, 'abcdefghijk')

  Now if I look for these characters individually, it does not find anything..Is this an MS bug?

  Any help is appreaciated, thanks..

• bledu

  SSChampion

  Points: 12335

  More actions

  July 24, 2007 at 10:31 am

  #721984

  kung lao, one post is adequate for your purposes, we will see it. please stop double posting.

  ---

  Everything you can imagine is real.
  

• kung lao

  SSC Veteran

  Points: 296

  More actions

  July 24, 2007 at 11:18 am

  #721996

  sorry, I needed a quick answer so I can get out a script today - won't do it again..

• Peter E. Kierstead

  SSCarpal Tunnel

  Points: 4114

  More actions

  July 25, 2007 at 9:15 am

  #722336

  You need to specify a collation that distinguishes between upper and lower case, such as...

  declare @Pattern varchar(250)

  set @Pattern = '%['+char(190)+'-'+char(192)+']%'

  SELECT PATINDEX (@Pattern collate Latin1_General_BIN,'abcdefghijk')

   

  ---

  
  PeteK
  I have CDO. It's like OCD but all the letters are in alphabetical order... as they should be.