Hi,

if you put a CHR(0) on SPT string, VFP send to ODBC a wrong string:

?Sqlexec(hconnect,"SELECT 'A"+CHR(1)+"'")
?Sqlexec(hconnect,"SELECT 'A"+CHR(0)+"'") && <--- errore ODBC

If VFP build the string with a parameters fields ODBC haven't problem.

The problem is on VFP SPT parser, it cut the string when found a CHR(0) char
( VFP C routine use z-string on input).

Fabio