Thread: Help with Search - Floating Point Number
View Single Post
Old 04-12-2011, 10:45 AM   #4
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 31,078
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by nynaevelan View Post
I just tried them both and both gives me the ones with no price plus all the ones with a price of zero.
I don't use that kind of field, so I don't have a test bed to try ideas on

There are additional terms to use with a (Not) search:
you could try with a 0 value instead of the penny I chose

BTW If you sort the #price column, doesn't the blanks float to one end and the 0's to the other?
theducks is offline   Reply With Quote