View Single Post
  #9 (permalink)  
Old July 7th, 2003, 08:55 AM
Jeff Mason Jeff Mason is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

You could also try the 'nz' function:
Code:
SELECT COUNT(*) FROM Image WHERE nz(User1, 0) > 0

or

SELECT COUNT(*) FROM Image WHERE nz(User1, 0) = -1
Jeff Mason
Custom Apps, Inc.
www.custom-apps.com