Don't know if this will work for you or not. (Depends on the database, too...)
However, my first thought was concatenation. Some SQL like, select concat(last, name) as lastname. I'm sure that syntax isn't exactly correct, but a quick Google of concat sql and whatever db you're using will supply the syntax you need. hth, Rick -----Original Message----- From: Torrent Girl [mailto:[email protected]] Sent: Friday, November 04, 2011 11:49 PM To: cf-newbie Subject: columns with 2 words Hi All I am working with a very complicated stored proc which formats some of the column names into 2 words like 'LAST NAME'. This was used in ASP fine but in CF it is breaking (select LAST NAME from....) I remember a few years back, I ran into this same issue. I had a solution for it but I can't remember what it was. I thought it was SELECT [LAST NAME] as lastName....(QoQ) but that isn't working. Does anyone have an insight on how to do this? Thanks P.S. the stored proc can't be edited. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5712 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
