Re: CONCAT doesn't work with NULL?

[ewen fortune]

Hi Afan,
You can use concat_ws

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat-ws
---
CONCAT() returns NULL if any argument is NULL.
CONCAT_WS() does not skip empty strings. However, it does skip any
NULL values after the separator argument
---

Ewen

On Wed, May 14, 2008 at 5:53 PM, Afan Pasalic <afan@stripped> wrote:
> hi,
>
>  I have query
>  SELECT CONCAT(r.first_name, ' ', r.last_name, '\n', r.organization, '\n',
> r.title, '\n', a.address1, '\n', a.city, ', ', a.state, ' ', a.zip, '\n',
> r.email)
>  FROM registrants r, addresses a
>  WHERE r.reg_id=121
>
>  if any of columns has value (e.g. title) NULL, I'll get as result 0
> records.
>  If query doesn't have concat() - it works fine.
>
>  Why is that?
>
>  -afan
>
>  --
>  MySQL General Mailing List
>  For list archives: http://lists.mysql.com/mysql
>  To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>