Hi!

I need to perform search that uses like predicate and some of the wildcard characters for SQL Server ('%' or '_'), but not to treat them as wildcard characters.

Is there a way to do this?

Thanks!

use [%]. See LIKE in Books online (at the bottom)