Escaping special characters in SQL Server 2008

Question

I need your help on this: I am using SQL Server 2008 and have a stored procedure which is used to retrieve values from a table column.

Column of table contains description which could have anything including all special characters.

Is there any way I can escape all special characters ?

Thanks

Answer 1

try this

WHERE Description LIKE '%\ any text%'

here \ means ESCAPE