>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 >
You mean do the concat in my CF code? I am not understanding. The column from the stored proc is in 2 words - First Name so I think a concat will cause an error also. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:5713 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
