Re: Select NULL and Unique

Article View: borland.public.vdbase.data.sql

Article #746

Back to borland.public.vdbase.data.sql Previous Next

#746

From: David Madison
Date: Thu, 09 Jul 1998 00:00

23 lines
1165 bytes

Eryk Bottomley wrote:
> 
> David,
> 
> >How do I create a SQL statement to NOT select fields that are blank.  It
> >is a character field, and when I try select * from mdbf for mfield IS
> >NOT NULL, I still get rows that contain the blank field in my result
> >rowset.
> 
> SELECT * FROM MYTABLE WHERE (MYFIELD IS NOT NULL)
> 
> ...is standard SQL syntax.
> 
> >How do I achieve the equivalient of a unique index, to eliminate
> >duplicates in my rowset?  I have a unique index available, so do I
> 
> SELECT DISTINCT .....blah
> 
> Eryk

Thanks, I'll give these a try.

--David

Technical Details

Message-ID: <35A5016C.3450@compuserve.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <35A3AD4A.5A37@compuserve.com> <6o22f8$ktq3@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,6f7a5dab459b19d0
X-Google-Attributes: gidff5a1,public
From: David Madison <davidmadison@compuserve.com>
Subject: Re: Select NULL and Unique
Date: 1998/07/09
Message-ID: <35A5016C.3450@compuserve.com>
X-Deja-AN: 369932068
Content-Transfer-Encoding: 7bit
References: <35A3AD4A.5A37@compuserve.com> <6o22f8$ktq3@forums.borland.com>
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message