I'm poking around the Books Online for MS SQL trying to find if there's a way to do this:
In ColdFusion, you can do "(variablename) MOD (value)" to see if the value of the variable divides evenly by the supplied value or not. Not sure how to do a SELECT doing that same style check on a field value, though. In my case, I've got a field in a table that either will be a multiple of 100 or not, and I want to be able to get all of the records of one group or the other. --Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1664 Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:> ColdFusion MX 6.1, now 2.5 times faster. http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803
