View Single Post
  #7 (permalink)  
Old July 6th, 2003, 10:18 PM
KenSchaefer KenSchaefer is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Sydney, NSW, Australia.
Posts: 111
Thanks: 0
Thanked 0 Times in 0 Posts
Default

SELECT COUNT(*) FROM Image WHERE IsNumeric(User1) AND User1 IS NOT NULL

will work. I don't think you want to use VAL() if you can avoid it.

Cheers
Ken

www.adOpenStatic.com