This gives you the error...? CASE WHEN cc.cc_type_ID = 1 THEN @careCB + 1 WHEN cc.cc_type_ID = 2 THEN @careFBC + 1 WHEN cc.cc_type_ID = 3 THEN @careSBC + 1 WHEN cc.cc_type_ID = 4 THEN @careVACC + 1 WHEN cc.cc_type_ID = 5 THEN @careOFCC + 1 ELSE 0 END AS myvar
On Thu, Dec 13, 2012 at 3:45 PM, Scott Stewart <webmas...@sstwebworks.com>wrote: > CASE > > WHEN cc.cc_type_ID = 1 THEN @careCB + 1 > > WHEN cc.cc_type_ID = 2 THEN @careFBC + 1 > > WHEN cc.cc_type_ID = 3 THEN @careSBC + 1 > > WHEN cc.cc_type_ID = 4 THEN @careVACC + 1 > > WHEN cc.cc_type_ID = 5 THEN @careOFCC + 1 > > ELSE 0 > > END > -- John Bliss - http://about.me/jbliss ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353453 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm