Find a word in the table

RIAS used Ask the Experts™

on 2017-10-31

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

View Solution Only

Vitor MontalvãoIT Engineer

Trusted Expert

Distinguished Expert 2017

Commented: 2017-10-31

Use the LIKE keyword:

SELECT *
FROM TableName
WHERE Statement LIKE '%DELETE%'

RIAS

Author

Commented: 2017-10-31

Thanks!

Do more with

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

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

Facebook
Twitter
LinkedIn
https://www.experts-exchange.com/questions/29065631/Find-a-word-in-the-table.html copy