how to look for _(underscore)?

• pat-261672

  Hall of Fame

  Points: 3325

  More actions

  June 6, 2008 at 10:41 am

  #183184

  Hi all,

  how can i query to see if i have _(underscore) in text such as

  select * from table

  where desc like '%_%'

  Thanks

  Pat

• PW-201837

  SSC-Insane

  Points: 20805

  More actions

  June 6, 2008 at 10:52 am

  #825592

  See BOL under heading "Pattern Matching in Search Conditions"

  Enclose the wildcard character in square brackets:

  Where Column LIKE '%[_]%'

• noeld

  SSC Guru

  Points: 96590

  More actions

  June 6, 2008 at 11:30 am

  #825614

  pat (6/6/2008)

  ---

  Hi all,

  how can i query to see if i have _(underscore) in text such as

  select * from table

  where desc like '%_%'

  Thanks

  Pat

  select * from table

  where desc like '%\_%' ESCAPE '\'

  
  * Noel