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.