Quotation

Question

Post reply

Quotation

clucasi

SSCrazy

Points: 2113
More actions
May 26, 2010 at 3:41 am

#139162

I have written a stored procedure that updates data, it runs ok until it reaches the name Milly's.
I know the problem is with the quotation but I am not sure how to correct it.
the fields are ORG= '''+@FIELD1+''',
Field 1 equals Milly's
Edited: Today @ 10:35:03 AM by clucasi
May 26, 2010 at 5:42 am

This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 1

Cross Post

http://www.sqlservercentral.com/Forums/FindPost928060.aspx

Please keep to one thread.

Clear Sky SQL
My Blog[/url]

clucasi SSCrazy Points: 2113 More actions · Answer 2

i have tried to use the below code but it errors

,ORGANISATION= '''+@FIELD18.replace("'","''")& ''' ,

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 3

In SQL2008 you can do this:

',ORGANISATION = ' + convert(varchar, cast(@FIELD18 as varbinary ),1)

In SQL2005 you need to use system function:

',ORGANISATION = ' + master.dbo.fn_varbintohexstr(cast(@FIELD18 as varbinary ))

See, you will not even need a quotes!

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]