Query empty fields

From: Svein Fossdal <sveinf_at_petrodata.no>
Date: Wed, 21 Feb 2001 06:55:15 GMT
Message-ID: <iDJk6.53931$3h1.2321848_at_pouncer.easynews.com>


Does anybody know how I can select records that have empty varchar values?
I did the following, but nothing seems to work: sql> select train||','||train_type||',' from   2 trainpark where train_id in (216,215); train||','||train_type||','



,,
,,

sql> select train_id from trainpark where train=''; no rows selected
sql> select train_id from trainpark where train=null; no rows selected
sql> select train_id from trainpark where length(train)=0; no rows selected
sql> select train_id from trainpark where train in (''); no rows selected
sql> select length(train) from trainpark where train_id   2 in (215,216);
length(train)


sql>

I appreciate any help

Regards,

Svein Fossdal Received on Wed Feb 21 2001 - 07:55:15 CET

Original text of this message