select concat(ifnull(Field1,'NULL'), Filed2) from My Table;
----- Original Message ----- From: "A Z" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 31, 2004 2:25 PM Subject: Concat > > Hi, > > Concat() returns Null if any field in the field list > is Null. How can I use it to return a String > regardless, or is there another function to do it? > > regards > > > > > > > ___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com > > -- > 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]