>I believe this works in SQL Server (not tested) and for sure in VFP:
>
>SELECT 1=2 AS MyField
>
It doesn't work in SQL Server, that was the first thing I tried yesterday night when I saw this question. So, I agree with Dragan.
>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.
If it's not broken, fix it until it is.
My Blog