Posted by Bruce A. Julseth on 04/29/07 21:44

"Bruce A. Julseth" <bruceaj_nospam_@bellsouth.net> wrote in message
news:f13364$b8f$1@aioe.org...
>I have forgotten how to do this (At least I think I knew how)
>
> I have SELECT CONCAT(A, ' ', B) as C ........
>
> If A or B is NULL this select fails. What do I need to do so it won't
> fail...
>
> Thanks...
>

Never Mind. I found it on the internet...

SELECT CONCAT_WS('', A, ' ', B) as C .....

Thanks....

[Back to original message]