Use the VAL function on the 01 value so that 1 = 1. Kevin >>> [EMAIL PROTECTED] 05/10/01 01:56PM >>> Hello, i'm passing a number from a form and then comparing it with a number pulled out of the DB (SQL server) but when i do the comparison it's against 1 (passed by the form) and 01 (passed by SQL). Can anyone tell me how to format the number coming from the form and CF to pass or be written as 01? Thanks. d ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
