Re: Concat

[Mikhail Entaltsev]

select concat(ifnull(Field1,'NULL'), Filed2) from My Table;


----- Original Message ----- 
From: "A Z" <xtcsuk@stripped>
To: <mysql@stripped>
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/mysql?unsub=1
>
>