SQL - Join two columns into one

Hello,


In my current Query I return two columns Desc_ and Desc2, this is where the description falls onto two lines. When I put these into excel I insert a new column and put in the following formula
=[desc_]&" "&[desc2]
Which then gives me one full description, then I hide the original two columns

My question is; is there a way to do this within the query so as to make the output a bit neater?

Any help would be much appreciated

Cheers,

Kenny

Use

[desc_]+[desc2]

in the SQL

cheers bob, is there a way of putting a space inbetween?

Yes

[desc_]+" "+[desc2]