Find a word in the table

Hello,
I have tableA  with columns Statement, Datetime.
In the statement column I need to  search a word 'Delete' .How can I do this?

Regards
RIASAsked:
Who is Participating?
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
Use the LIKE keyword:
SELECT *
FROM TableName
WHERE Statement LIKE '%DELETE%'

Open in new window

1
 
RIASAuthor 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.

Advertise Here