- #1
- 6,934
- 10,341
Hi all,
I have a table Emp ( EmpFName, EmpMidI, Emplast) ,
where EmpMidI is the middle name initial, which may be null. I want to get the full name in a single
record, which I would do, if there were no nulls, as :
Select EmpFirst + ' ' + EmpMidI + ' ' + Emplast AS [fullname]
How do I rewrite this query to allow for null middle initials?
Thanks.
I have a table Emp ( EmpFName, EmpMidI, Emplast) ,
where EmpMidI is the middle name initial, which may be null. I want to get the full name in a single
record, which I would do, if there were no nulls, as :
Select EmpFirst + ' ' + EmpMidI + ' ' + Emplast AS [fullname]
How do I rewrite this query to allow for null middle initials?
Thanks.