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