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