Combine First and Last Name as FullName

[Newsgroup_User]

I'd like to write a statement that combines the First Name and Last Name
as FullName (with a space separating the two).

This doesn't work:

SELECT ContactID, LastName + ', ' + FirstName AS FullName

Any ideas?

[Newsgroup_User]

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

[tclaremont]

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.

[Newsgroup_User]

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.

[Newsgroup_User]

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?

[Newsgroup_User]

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

[Newsgroup_User]

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

Thanks Tim, that did the trick.