In my table,I have FirstName,MiddleName,LastName columns and I want to display the total name with column heading Name.
When I am doing this,If any of the value is NULL,I am not getting the required output.Instead,I am getting NULL values.How to handle it.?
My query looks like this,
Select t.FirstName+' '+t.MiddleName+' '+t.LastName Name from Client as t
Please help me.