General information
Title:
Quotes in SQL Server
Version: VFP 5.0
I am using SQLPREPARE() and SQLEXEC() to UPDATE and INSERT records into a SQL Server 6.5 table. In Transact-SQL, the string must be surrounded with single quotes e.g., ...SET Lname='Smith'...
How can I define a string that has a single quote in it?
Such as SET Artist='Jane's Addiction'
Any thoughts?
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