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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]