Hi Brian,
The best query will be
Select * from where not
this is valid for all column types
otherwise for specific col type you can use
Select * from where ="" (for text)
Select * from where = 0 (for integer) and so on..
regards,
Anirban
-Original Message-
From: [EMAIL PROTE
Hi Brian,
If you want to select records where a text column has no values do the
following:
Select *
>From
where = ""
is the name of your table
is the name of your column
HTH
Peter
Peter Horsbø
>>select blank records within a column ?
Select * from MYTABLE
Where not MYCOLUMNNAME into Selection
Browse * From Selection
Jakob
**
Jakob Lanstorp [EMAIL PROTECTED]
Developer
Kampsax A/S - GSL