>If I run the following example in VFP command window, all works well. But if I run this code in a VFP stored procedure called via Ole Db provider, the value that goes into the field is blank/empty:
>
>

>
>create table ("MyTest") free ( test_str c(200) )
>
>cTestStr = "Test & test"
>APPEND BLANK IN mytest
>replace test_str WITH cTestStr IN mytest
>
>*-- The value that goes to field TEST_STR is blank when
>*-- calling this code via Ole Db Provider.
>

>
>What am I missing?
Try

cTestStr = "Test " + chr(38) + " test"