Is there a way to do this using a variable?
--- Blackberry Email -------
Turner, Padget, Graham and Laney P.A.
Steven Lancaster
Phone - (803) 227-4368
[Email address protected]
-----Original Message-----
From: Paul Schlieper <mssqldba-ezmlmshield-x22487606.[Email address protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Tue Jun 28 11:57:08 2005
Subject: RE: Defeat Single Quotation in a string
Double it up:
update response_op_bk_1
set response = 'Call Jeff'
where response = 'Call Jeff''s cell'
and responsenumber = '1'
-----Original Message-----
From: Carl
[mailto:mssqldba-ezmlmshield-x30014409.[Email address protected]
Sent: Tuesday, June 28, 2005 11:54 AM
To: LazyDBA Discussion
Subject: Defeat Single Quotation in a string
Hello all,
I need to defeat a single quotation that is in a where clause to
update a table, anyone have any suggestions SQL thinks that the single
quotation mark after Jeff is the end of the string value. See sample of
code below.
update response_op_bk_1
set response = 'Call Jeff'
where response = 'Call Jeff's cell'
and responsenumber = '1'
Thanks in advance...
Carl Phillips
Regions Bank
I.S. Engineer
PMPM Level II Support
W 334-956-6169
C 334-799-8632
800-272-2867
--------------------------------------------
This e-mail and any files transmitted with it are the property of
Regions Financial and/or its affiliates, are confidential, and are
intended solely for the use of the individual or entity to whom
this e-mail is addressed. If you are not one of the named
recipient(s) or otherwise have reason to believe that you have
received this message in error, please delete this message
immediately from your computer. Any other use, retention,
dissemination, forwarding, printing, or copying of this e-mail
is strictly prohibited.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
CONFIDENTIAL & PRIVILEGED
Unless otherwise indicated or obvious from the nature of the above communication, the information contained herein may be an attorney-client privileged and confidential information/work product. The communication is intended for the use of the individual or entity named above. If the reader of this transmission is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.
If you have received this communication in error or are not sure whether it is privileged, please immediately notify us by return e-mail and destroy any copies, electronic, paper or otherwise, which you may have of this communication.
'*,'".
MS Sql Server LazyDBA home page