Re: Select statement with a NULL


"Bruce A. Julseth" <bruceaj_nospam_@xxxxxxxxxxxxx> wrote in message
news:f13364$b8f$1@xxxxxxxxxxx
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....


.