Alternatives are:
select * from myTable x
where x.Description like '%text%'
select * from myTable x
where PATINDEX('%text%',x.Description)>0
select * from myTable x
where CHARINDEX('text',x.Description)>0

I doubt there is much difference between them though you would think that CHARINDEX has less logic in so it should be faster, but I don't think that's the case.