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|||This is a multi-part message in MIME format.
--=_NextPart_000_00CD_01C6800F.9C65F470
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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@.TK2MSFTNGP02.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 > >
--=_NextPart_000_00CD_01C6800F.9C65F470
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Please view
Escape the '\' character
Message that I just sent
T.Y.
Samuel
"Paul Ibison"
--=_NextPart_000_00CD_01C6800F.9C65F470--|||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
>
>
No comments:
Post a Comment