In your selection you can use "Where Logical_column" to get all the rows where
Logical_column is true, or "Where Not Logical_column" to get all the rows where
Logical_column is false.
____________________Reply Separator____________________
Subject: MI true or false in SQL
Author: "Nick Hall" <[EMAIL PROTECTED]>
Date: 07/21/2000 1:14 PM
Dear L-ers,
I have a large MapInfo table that has a logical column (i.e. T or F).
When I come to query that field for the false rows (i.e. where Logical_column =
"F") it selects all the true values (i.e. "T").
Also, if I ask the query the other way round and try to select all the rows that
don't equal false it does select all the false records (i.e.where Logical_column
<> "F").
Can anybody explain this please - it happens in V5, V5.5 and V6.
TIA
Nick Hall
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
