>Hi Fred
>
>>Well it worked just fine with VFP tables and local views, and it also just worked fine with SQL7. What does your SPT code look like? REPLACE works just fine.
>
>I'm guessing that it's something in the OCBC driver - both SPT and Remote Views use ODBC, whereas a local view doesn't.
>
>Our SPT code is part of our framework and works fine except in this instance where chr(0) is involved.
>
>Best.
>
>Matt.
I tried SPT also, and everything worked just fine.
My SQL server driver is 3.70.08.21 and seems to work fine. Maybe it is a code page problem, but I haven't changed mine from whatever a US W2K setup provides.