OK, looks like the SQL format is sorta: SELECT column1, column2 , CASE dsp_millthou WHEN 'thousand' THEN CAST(dsp_amount + '000' AS int) WHEN 'million' THEN CAST(dsp_amount + '000000' AS int) WHEN 'billion' THEN CAST(dsp_amount + '000000000' AS int) END FROM myTABLE
but that's not *quite* it. I'm getting an error: "Syntax error converting the varchar value 'Million' to a column of data type int." Still working on it... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308505 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4