Find a word in the table

RIAS
RIAS used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IT Engineer
Distinguished Expert 2017
Commented:
Use the LIKE keyword:
SELECT *
FROM TableName
WHERE Statement LIKE '%DELETE%'

Open in new window

Author

Commented:
Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial