How to check string in if condition in sql server 2005

Question

I want to check string in if condition:

For ex:if String contains string 'X' then it shouldsatisfy certain condition.

if(contains(var,'xyz'))
begin
-----
end


This querry given me error.

How should i check string?

Plz help me out.....