Re: CONCAT doesn't work with NULL?

[Afan Pasalic <afan@xxxxxxxx>]

actually, this will not work for me (or I got it wrong :D) because I 
need to have street, state and zip in one line and with separator 
defined on the beginning it will put everything in separate lines.
:D




ewen fortune wrote:
> 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@xxxxxxxx> 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=ewen.fortune@xxxxxxxxx

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx