Hi Sergey,

this is a MS SQL bug.

try this in SQL Analyzer:

SELECT
'ABC\
TEXT',
'ABC\'+'
TEXT'

It appear in VFP because:
- with a memo type VFP do a string substitution
- with a char type VFP do a ODBC parameter substitution

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