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;
  1. 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.