I have a program that creates an SQL pass through statment to update a memo field in an SQL table. Here's the code:

lcDiary = "It's great to be alive"
l_cSQL ="UPDATE tmtrans SET diary = '"+ lcdiary+ "' WHERE id = 11 "
? sqlexec(1,l_csql)

The return is a -1 and the error states Incorrect syntax near s. The problem is caused because there is a ' in the variable lcDiary.

I tried to use double quotes in the l_cSql variable but that does not work. Furthermore, I may have cases were users key in both ' amd " quotes. I want to be able to change the delmiter in SQL server prior to executing my command to somethinhg like "{". I could then write a function to determine if the delimiter was in the text and set SQL correctly prior to updating the table. Can anyone help with changing the SQL server setting?

Thanks in advance....