> I'm checking the field before I call CFQUERY. The value is 38. Any ideas? Could you send a little more of a code snip? Exactly as it is in your template? Sometimes that helps a bit. This seems like it should be pretty straightforward so maybe there's something else going on...