Re: Query empty fields

On Wed, 21 Feb 2001 06:55:15 GMT, "Svein Fossdal" <sveinf_at_petrodata.no> wrote:

>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||','
>-------------------------------------------------------------------

select train_id from trainpark where train is null; Received on Wed Feb 21 2001 - 08:22:00 CET