I am trying to replae single quotes ( ' ) with the word 'ft' in our database table.
Below is the syntax I am using:
Set MetaDescription = RTRIM(LTRIM(Replace(MetaDescription, ' ' ', 'ft' ))),
LongDescription = RTRIM(LTRIM(Replace(LongDescription, ' ' ', 'ft')))
But I get the error msg:
Msg 105, Level 15, State 1, Line 2
Unclosed quotation mark after the character string '', '))) '.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '', ')))
I have tried enclosing the single quote in double quotes as in ( " ' " ). Still no luck.
Thanks for your help.