PATINDEX bug?

• kung lao

  SSC Veteran

  Points: 296

  More actions

  July 24, 2007 at 9:45 am

  #173984

  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:22 am

  #721980

  please do not double post, we are working on your problem

  ---

  Everything you can imagine is real.