How to check if a piece of text is in a table?

Question

SQL

Good day!
I have a problem, I need to check if there is a part of the text in the table from the mssql database.
There is a table:
Id Data
1 0x010010000101110
2 0x011010010100110
etc.
There is also a part of the query: 1110
it is necessary to check through IF whether this part of the text is in the date
(at the beginning of the query, I only select a certain string, for example, the one where id=1 and all its variables are described, that is, you do not need to do a SELECT)
Can you tell me how to do it?

Answer 1

through if, in the sense through the sql if statement?
can't use like or regexp operators?
like, in sql if it works like this:
Can you explain this part more precisely? Does it confuse you that SELECT is written first?

Answer 2

SELECT IF("PIVO" LIKE "%VO%" , "YES", "NO");