subject:"Concatinating Two Columns"

Re: Concatinating Two Columns

2004-11-13 Thread Bertrand

SELECT AttID ,SessionDate , CONCAT( FirstName, " ", LastName ), Present FROM myTable - Original Message - From: "GH" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, November 14, 2004 5:32 AM Subject: Concatinating Two Columns > I would like

Concatinating Two Columns

2004-11-13 Thread GH

I would like to know how I can make two columns out put as one? For Example I have +---+-+--+---+-+ | AttID | SessionDate | LastName | FirstName | Present | +---+-+--+---+-+ | 2 | 2004-10-30 | Smith | Dale