Posted by Jack Jackson on 08/14/07 06:35

On Tue, 14 Aug 2007 06:09:18 GMT, "SafeEarthSafeChild"
<safeearthsafechild@yahoo.com> wrote:

>In TransactSQL % is the wildcard
>SELECT *
>FROM Table
>WHERE Table.Field LIKE '%Example%'
>
>But how do I find "% solids" or just "%"?

The SqlServer TransactSQL Help says there are two ways to do this.
1. Enclose the % in square brackets.
2. Use the ESCAPE clause to specify a character that makes the next
character be treated as an ordinary character:
match_expression [ NOT ] LIKE pattern [ ESCAPE escape_character ]

[Back to original message]