Queries using LIKE wildcards in sql server

Try this query:

select * from tablename where colname like '%' + @varname + '%'

Hope it helps.

WHERE
columnName LIKE '%' + myVarCharVariable +'%'

Use:

where columnA LIKE '%' + myVariable + '%'