*&$^&%$ Double and single quote in same string

Article View: comp.databases.ms-sqlserver

Article #146

Back to comp.databases.ms-sqlserver Previous Next

#146

From: Tom
Date: Wed, 22 Jul 1998 00:00

12 lines
1388 bytes

In a stored procedure I am building a dynamic string to be executed.  One of
the variables that is in the where statement has a double and a single quote
in it.  In order to execute my string I need to place it in either single or
double quotes but this will bomb if there are both in the string.  In oracle
and Informix they have escape characters to get around this.

Does SQL Server have some type of escape character to get around this.  Or
is there some other type of work around.

Thanks

Tom

Technical Details

Message-ID: <35b646c9.0@news.one.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f816f,58a0f30648015610,start
X-Google-Attributes: gidf816f,public
X-Google-Thread: ff490,58a0f30648015610,start
X-Google-Attributes: gidff490,public
X-Google-Thread: 104de1,58a0f30648015610,start
X-Google-Attributes: gid104de1,public
X-Google-Thread: 11301e,58a0f30648015610,start
X-Google-Attributes: gid11301e,public
From: "Tom" <somewhere@nospam.com>
Subject: *&$^&%$ Double and single quote in same string
Date: 1998/07/22
Message-ID: <35b646c9.0@news.one.net>
X-Deja-AN: 373938895
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
X-Trace: 22 Jul 1998 16:08:41 -0500, 207.78.240.226
X-Authenticated-User: schraer
Organization: OneNet Communications News Hub
Newsgroups: comp.databases.ms-sqlserver,cz.comp.microsoft.sql,microsoft.public.sqlserver.misc,microsoft.public.sqlserver.programming