>>>>>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"

>>>
>>>I will try it. But the point is that the value [& + amp + ";"] (which by the way UT shows here as "&") inserted into the string outside my control.
>>>
>>>Thank you.
>>
>>Try to replace the ampersand with some other character, and do a similar replacement afterwards to put it back again. A pair of chrtran() will do the job.

I tried STRTRAN() but it does not work when called in the stored procedure via Ole Db. Even though that STRTRAN() is not on the list of unsupported command.

I will try chrtran()

Thank you.