View Single Post
  #8 (permalink)  
Old July 7th, 2003, 03:48 AM
owain owain is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Cardiff, , United Kingdom.
Posts: 231
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Ken, your query will work, however the acceptable values for my column are a positive integer and -1. I need to be able to differentiate between the two so I am using 2 queries:

Code:
SELECT COUNT(*) FROM Image WHERE Val(User1 & "") > 0
to test for positive integers and

Code:
SELECT COUNT(*) FROM Image WHERE Val(User1 & "") = -1
to test for -1. The query you suggested will only test for the existence of a number.

Regards
Owain Williams