Add "" within concat
Posted: Wed Apr 08, 2009 8:26 am
Hi,
Can I add a function within the concat which adds " " on b.nickName?
To get firstname "nick" lastname, and just not a separator between the names.
thanks!
edit:
And also if nickName == 0 it should not show. I guess that might not be possible in the query though.
Code: Select all
CONCAT_WS(' ', b.firstName, b.nickName, b.lastName)To get firstname "nick" lastname, and just not a separator between the names.
thanks!
edit:
And also if nickName == 0 it should not show. I guess that might not be possible in the query though.