> >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 > > >
I guess I should have asked this: How do you output columns that consist of 2 words like 'First Name'? > 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:5714 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
