You have at least 2 options (witch came instantly in my mind):
CONCAT_WS - concatenation with separator
SELECT CONCAT_WS('/', firstname, lastname) AS name FROM tablename
CONCAT - concatenation of arguments
SELECT CONCAT(firstname, SPACE(1), lastname) AS name FROM tablename
ATTN: SPACE(n) - generates a string with a space in it !
--
Gabriel PREDA
Senior Web Developer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
