Hi Naomi.
Just what I wnated.. many thanks
Regards,
Gerard


>>In Vfp, to create a Logical field, I do the following:
>>Select *, .T. as MyTrue, .f. as MyFalse from MyTable ..... ends up with MyTrue and MyFalse as Logic Fields (True or False)
>>
>>How do I do the same in SQLSERVER and C#, I want to end up with a Bit Column (Not a numeric Column) as the table is going to another system which expects a Bit field .
>>
>>Tia
>>Gerard
>
>select cast(1 as bit) as MyBitField ...