Escpae characters

Hi
I am looking for a reference that lists all special characters in SQL Server
that must be escaped and how
Thank you
Samuel ShulmanSamuel,
have a look in BOL for 'escape characters'. You can use the keyword ESCAPE
to escape a character, and the ones this might apply to are the wildcards
used in pattern matching.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Please view
Escape the '' character
Message that I just sent
T.Y.
Samuel
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:OxUT7b$fGHA.2032@.TK2MSFTNGP0
2.phx.gbl...
> Samuel,
> have a look in BOL for 'escape characters'. You can use the keyword ESCAPE
> to escape a character, and the ones this might apply to are the wildcards
> used in pattern matching.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
>|||Just want to add that whether a character is special and requires escape
depends on the context. The doc under 'escape characters' in BOL talks about
escape characters in search conditions. Delimited identifiers are another
context in which characters such as ] (if delimiters are [ and ]) should
be
escaped.
Linchi
"Paul Ibison" wrote:

> Samuel,
> have a look in BOL for 'escape characters'. You can use the keyword ESCAPE
> to escape a character, and the ones this might apply to are the wildcards
> used in pattern matching.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
>