Many thanks Borislav.
That worked fine.
Regards,
Gerard


>>Got Insert working fine for Character fields, but cant get a 'Bit' field to update
>>e.g. tried >> 1 , 'true' .t. , and get an error all the time
>>
>>Anybody know how to unpdate a BIt field in SQLSERVER using Insert
>>Tia
>>Gerard
>
>

>TEXT TO lcSQL NOSHOW
>    INSERT INTO YourTable (BitField)
>    VALUES (?lbBit)
>ENDTEXT
>lbBit = .t.
>? SQLEXEC(lnHandler, lcSQL )
>
>lbBit = .f.
>? SQLEXEC(lnHandler, lcSQL )
>