I am doing a update sqlexec command in my system and i am haveing trouble with my update command because some of my memo fields have ' marks in it, which makes my sql server error out before it gets to the end of my sql command. Does sql passthrough on sql server require the ' marks around all char field or is their another way I can insert this directly into a sql server text field.

Example:
SELECT References_main
SCAN
lcSql = "UPDATE Referenc Set rf_ordr = '";
+ ALLTRIM(References_main.rf_ordr) + "',";
+ "rf_para = '" + ALLTRIM(References_main.rf_ordr) + "',";
+ "rf_Title = '" + ALLTRIM(References_main.rf_Title) + "',";

* Below is a memo field

+ 'rf_text = "' + REFERENCES_MAIN.rf_text + '"';
+ " WHERE rf_num = " + ALLTRIM(STR(references_main.rf_num))

lnTest = SQLPREPARE(THIS.ln130Checklist,lcSql)
ENDSCAN