combine two collums

[mmorgensen]

Is there any way to combine two collums into one? Say I have a collum named "firstname" and one as "lastname", could I create a query to return them both within the same collum?


Firstname | Lastname
matthew | morgensen


results

'matthew morgensen'

?

mm

 

[mmorgensen]

sorry for the bad spelling...a world w/ spell check has turned me into an bad speller

Columns

mm

 

[Zathras]

SELECT firstname + ' ' + lastname as FULLNAME