Concatenations Firstname+middlename+last name

[dwight1]

Hi,

I have concatenated the names in sql as follows

[BFirstname] + ' ' + [bmiddlename] + ' ' + [blastname] AS Borrower1

and it works good when we have the middlename, but if we do not have the middlename it just gives blank.


Can any one advise how do i make it work in case of a null value in the concatenation.

Thank you
Dwight

 

[Golom]

[BFirstname] + ' ' + IsNull([bmiddlename],'') + ' ' + [blastname] AS Borrower1

 

[dwight1]

Thank you very much. It was very helpful.