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?