[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_
