>>>Hi,
>>>
>>>I have an expression that works SQL Server DB:
>>>

>>>select  CAST(0 AS BIT) AS MYFIELD
>>>

>>>
>>>Of course the above will not work for VFP. Is there a way to change the expression above that it would create a calculated logical field in VFP as well as SQL DB?
>>>
>>>TIA
>>
>>I believe this works in SQL Server (not tested) and for sure in VFP:
>>
>>SELECT 1=2 AS MyField
>>
>>In MySQL this syntax does not work. I usually refrain from creating boolean fields in the database and prefer single digit numeric values instead (0=false, 1 = true). In MySQL you cannot cast to bool (although the data type exists) and SQL Server boolean datatype does not exist.
>
>Thank you. I decided to have two separate expressions, one for SQL and one for VFP.

I found another alternative:

PRIVATE plValue
plValue= .F.

Select  ?plValue AS MYFIELD