SQL Server statement Where myfield content giving sub-string

Question

Greetings,

I'm looking for a SQL Server statement to retrieve records Where myfield content giving sub-string.

Thank you,

Answer 1

You can use CharIndex

Select * From YourTable
Where
CharIndex('yoursubstring', myfield) > 0

Answer 2

Try PatIndex.

SELECT *
FROM Table
WHERE patindex('%string%', data ) > 0

Answer 3

select * from mytable where myfield like '%literalstring%'

or

select * from mytable where myfield like '%' + @stringvar + '%'

...not really clear on whether your substring is a literal or a variable

Answer 4

Another possibility is to use LIKE:

SELECT
    MT.column_1,
    ....
FROM
    My_Table MT
WHERE
    some_column LIKE '%' + @search_string + '%'