|
|
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....
Navigation:
[Reply to this message]
|