General information
Forum:
Microsoft SQL Server
Hi All,
Currently I am writing a visual foxpro program to write data / record to sql server. However there is a problem when I failed to update the sql table when there is " ' " in the string. Example: update the "21' lcd monitor"
update tbl_item set description1 = ' 21' lcd monitor ' where item = '0001'
How could I include the " ' " in the string?
Thanks for your help in advance.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only