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>
,,
,,
Date: Wed, 21 Feb 2001 06:55:15 GMT
Message-ID: <iDJk6.53931$3h1.2321848_at_pouncer.easynews.com>
,,
,,
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