Use two quotes in a row, e.g. SET Title='Been Caught Steelin'''

>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?