SELECT 'ABC\ TEXT', 'ABC\'+' TEXT'It appear in VFP because:
REPLACE memoField WITh 'A\'+chr(13)+chr(10)+'END' SQLEXEC(h,'SELECT ?(memoField)') <= VFP send SELECT 'A\... SQLEXEC(h,'SELECT ?SUBSTR(memoField,1)') <= VFP send SELECT 'A\... SQLEXEC(h,'SELECT ?(memoField+[])') <= VFP send EXEC sp_sqlexecute 'SELECT @P1',...This is a VFP bug ( cut the string when found a CHR(0)):
REPLACE memoField WITh 'A'+chr(0) SQLEXEC(h,'SELECT ?(memoField)') <= VFP send SELECT 'A