>>Hi All:
>>
>>I have a VARBINARY field in my table called varb with a value of, say, 0h0000011111. I want to set up ten fields in my table (R1 to R10) that represents each bit, so that the user can easily change each bit.
>>
>>What syntax would I use to transfer each bit to the proper field such as:
>>
>>
>>Replace R8 with substr(varb,8,1) - which doesn't work.
>>
>>
>>THEN, once the user has completed his task, I would need the equivalent of
>>
>>
>>Replace varb with CharToVarbinary(R1 + R2 ... + R10)
>>
>>
>>Thanks,
>>
>>Yossi
>
>Did you check CTOBIN function? Also, are your data in VFP or SQL Server?
Naomi:
My data is in VFP.
I'll have to play around with the CTOBIN and BINTOC functions tomorrow, so far, I can't see how to use them to do what I want.
Thanks,
Yossi