Get Data from SQL Server without Null Values

This blog describe how to Get Data from SQL Server without Null Values.

I have a table like below structure:

FName           MName           LName

Gaurav           NULL                Kumar

Piyush            Sharma            NULL

How can I write a query so that I can get an output without null values. I dont want them in my result.

Gaurav Kumar

Piyush Sharma

Here is the solution;

select IsNull(FName,'') + ' ' + IsNull(MName,'') + ' ' + IsNull(LName,'') from tableName

IsNull function checks first paramter…. if it is null then second parameter is returned else first parameter is returned as it is.