>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

Fabio,

Can you pass it as an expression so that it is evaluated later ?

?Sqlexec(hconnect,"SELECT 'A'+CHR(0)")