Combine First and Last Name as FullName

Mountain Lover wrote:
> mysql docs are a good reference!
> CONCAT(LastName, ', ' , FirstName)
> HTH

Thanks Tim, that did the trick.

mysql docs are a good reference!
CONCAT(LastName, ', ' , FirstName)
HTH
--
Tim Carley
www.recfusion.com
info@NOSPAMINGrecfusion.com

tclaremont wrote:
> Try this:
>
> SELECT ContactID, (Trim(LastName)+", "+Trim(FirstName) AS FullName
>
> You are missing the ( and ).
>
> I like to put the Trim function in there in case there are leading or trailing
> spaces in the first name or last name fields.
>

That didn't work either. I added a left parentheses, Trim(FirstName)),
which still didn't work.

This sql is from Ben Forta's CFMX7 Web Application Construction Kit,
page 649. I'm amazed that this made the book, as all the other sql
statements have been correct.

Any other ideas?

Azadi wrote:
> which database are you using? correct sql statement to do it depends on
> the db... usually you use Concatenate() to do things like that...
> look up sql language reference for your db

I'm using MySQL 5 with CFMX7.

Try this:

SELECT ContactID, (Trim(LastName)+", "+Trim(FirstName)) AS FullName

You are missing the ( and ).

I like to put the Trim function in there in case there are leading or trailing spaces in the first name or last name fields.

which database are you using? correct sql statement to do it depends on
the db... usually you use Concatenate() to do things like that...
look up sql language reference for your db
--

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com