Concatenate two fields where one is null

[Cloonalt]

I use the following, but if only one of the fields that I'm concatenating is null, Comments returns as null. Both fields are string.


Select mmatter, mdesc2 + ' ' + mdesc3 as Comments from matter

Can't seem to find the syntax. Any help is appreciated.

 

[cLFlaVA]

you can't expect a null value to give you a blank string, because null does not mean blank, it means no value. blank is a value.

do this:

Select mmatter, isnull( mdesc2, '' ) + ' ' + isnull( mdesc3, '' ) as Comments from matter

*cLFlaVA
----------------------------
[tt]( <P> <B>)¹³ * (<P> <.</B>)[/tt]

[URL unfurl="true"]http://www.coryarthus.com/[/url]