Finding 'bad' characters

• Barcelona10

  SSCertifiable

  Points: 5419

  More actions

  June 22, 2026 at 8:03 pm

  #4871284

  Hi All

  I am trying to find 'bad' characters that users might type in. My query is finding them as expected, but the results include records that I think my query should not return.

  Here is my query

  select NOTES  , ascii(left(NOTES ,1))

  from trip with(nolock)

  where (patindex('%[^ !-~]%' collate Latin1_General_BIN, NOTES ) > 0 or

  patindex('%[|]%' collate Latin1_General_BIN, NOTES ) > 0)

  Unexpected record

  CXBC    67

  Thank you