That is T-SQL syntax, and needs to be passed to the server. VFP remote views interpret the bit field as a logical field.

Convert is a handy function, and can be found in the T-SQL docs.

>>I ran across this today. SQL Server stores logical fields at type bit.
>>
>>Try using 'Select convert(bit,0) as lField from ....'
>>
>>
>>>
>>>The SPACE(X) worked for the char column, but for the logical column I gat a "connectivity error, syntax bad near AS'...or something like it
>
>Is that VFP 5 compatible syntax? I will give it a go and let you know. I thought I saw the convert function somewhere, but couldnt find it anywhere. Where are the docs?