Updating string field with values that have quotations

[Luvsql]

I need to run an update statement but the text value has an " in it to depict inches.

UPDATE EQUIPMENT SET DESCRIPTION='PIPE WALLSPREADER FOR 1 1/2" (ID) WHERE CODE='ALLHA0009'

This yields an error "Unclosed quotation mark after the character string ''."

What syntax do I use in order to update text with "?

 

[bborissov]

You should have a closing single quote after (ID):

UPDATE EQUIPMENT 
      SET DESCRIPTION='PIPE WALLSPREADER FOR 1 1/2" (ID)[COLOR=red][b]'[/b][/color]
WHERE CODE='ALLHA0009'

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[simian336]

Missing a closeing single quote...

UPDATE EQUIPMENT
SET DESCRIPTION='PIPE WALLSPREADER FOR 1 1/2" (ID)'
WHERE CODE='ALLHA0009'

Simi

 

[simian336]

You beat me to it, Boris... : )

Simi

 

[Luvsql]

UPDATE EQUIPMENT
SET DESCRIPTION='20' X 20' - GOLD LAMÉ'
WHERE CODE='BUTTE0670'

This yields "Incorrect syntax near 'X'."

I have a single quotation within the description to describe 'feet.'

 

[gmmastros]

You need to double up your single-quotes when the single-quote is part of the data and not a string delimiter.

UPDATE EQUIPMENT 
SET DESCRIPTION='20[!]''[/!] X 20[!]''[/!] - GOLD LAMÉ' 
WHERE CODE='BUTTE0670'

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom