select * from mytable where a = "" or b = "" or c = ""....
Cheers
Martin
-----Original Message-----
From: Christian Malmquist [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 8 August 2000 23:45
To: [EMAIL PROTECTED]
Subject: MI Tiny SQL-problem!
I need a sql-query that returns only the rows that are empty. In the example
under row#1 is the one to be selected.
A B C
1 12 14
2 41 24 24
3 141 41 14
A small little problem that is driving me crazy!!!
-Christian Malmquist-
-www.pocket-it.com-
-www.hvor.no-
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]