Grouping 2 columns into 1!

HI,
i have 2 columns named firstname and lastname, i need to get them into 1 column named name with a space between them.
Does anyone have a tip to do this?
WimmoHi Wimmo,

just something like

select column_firstname + ' ' + column_lastname
from table

The "+" concatenates two CHAR or VARCHAR columns.

Carsten|||Originally posted by CarstenK
Hi Wimmo,

just something like

select column_firstname + ' ' + column_lastname
from table

The "+" concatenates two CHAR or VARCHAR columns.

Carsten

Thanx alot that did it

Greetz Wimmo