Concatinating Two Columns

[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       | Yes     |
+-------+-------------+----------+-----------+---------+

I would like to have it output as

+-------+-------------+----------------------+---------+
| AttID | SessionDate |         Name            | Present |
+-------+-------------+----------------------+---------+
|     2 | 2004-10-30  | Dale Smith         | Yes     |
+-------+-------------+----------+-----------+---------+

I have the following:
mysql> \s
--------------
mysql  Ver 12.22 Distrib 4.0.18, for mandrake-linux-gnu (i586)

Server version:         4.0.18
Protocol version:       10
Connection:             Localhost via UNIX socket
Client characterset:    latin1
Server characterset:    latin1
UNIX socket:            /var/lib/mysql/mysql.sock
Uptime:                 2 days 8 hours 8 min 48 sec

Threads: 2  Questions: 10654  Slow queries: 0  Opens: 123  Flush
tables: 1  Open tables: 30  Queries per second avg: 0.053
--------------

Thanks