Select col1 from Jenny where col1 is not null Should get you all of column 1 where there is not a null.
Thanks, John W. Herbold Jr. IS Specialist/DBA -----Original Message----- From: Christopher G Tantalo [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 12:46 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: question on null or 0 [EMAIL PROTECTED] wrote: > Why not use the following SELECT statement: > select col1 from jenny where col1<>0 and col1 is not null > > That should do the trick nicely. :) > > Gordon Dewis what if 0 *is* a valid entry for that particular row? chris -- ------------------------------- Just Your Friendly Neighborhood _SPIDEY_
