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
