How do you search for a STRING which begins with an underscore for example:

How do you search for a records which begin with an underscore for example:

_SQL
Mr_ShawAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
where yourfield like '[_]%'
0
 
Imran Javed ZiaConnect With a Mentor Consultant Software Engineer - .NET ArchitectCommented:
you can use square brackets to escape a sequence so you may use

Select * from tbl
Where col like '[_]%'

please reffer to following link for more details:
http://msdn.microsoft.com/en-us/library/ms179859.aspx

Thanks
0
 
Mr_ShawAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.