Thanks Shane. You were right that got everything straightened out. So if you are look for a long integer solution here it is short and sweet. (Sorry to put that in there however I haven't found a definitive answer in any other threads). Thanks to everyone for setting me straight. [Big Grin]
_________________________
Select * from users where clue > 0 [b]0 rows affected.[/b]