want 2 columns to look like 1 in sql statement 1

[AlbertAguirre]

Hello,
I have done this in access before but i cannot figure out how to do this in mysql.

I want to write an SQL statement that will join 2 columns together in the result set.

Example: (I want fname and lname to appear as full name in the result)

In access I used to do this:
SELECT fname & " " & lname as fullname FROM table

Result should be:
fullname
========
John Smith
Jane Doe

How do i do this in MySql?

 

[r937]

select concat(fname,' ',lname) as fullname ...



rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[AlbertAguirre]

Thanx!