On Thursday 24 August 2006 10:27, Srinivas Iyyer <srini_iyyer_bio(at)yahoo(dot)com>
wrote:
> tar_id | mid | seq_id | lscore
> --------+-------+--------+--------
> 32014 | | 50473 | 814
> 32015 | 67 | 50473 | 814
> The mid column is empty in certain places. how can I
> search if there are empty spaces in mid.
>
select tar_id from table where mid is null;
(assuming it's a numeric and not a text field set to '')
--
Alan