How do you check if a field contains a string in SQL?

Asked by Callen Becker

— To find an exact string SELECT * FROM [table] WHERE [field] LIKE ‘%stringtosearchfor%’.

  1. — To find an exact string.
  2. SELECT * FROM [table] WHERE [field] LIKE ‘%stringtosearchfor%’.
Andrew Henderson, BA Contributor
Andrew Henderson
4.8/535 ratings

Leave your comment

Leave a Comment

Your email address will not be published. Required fields are marked *