SQL

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;
  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.
Ebook Download
View all
Basic SQL Queries
Read by 19.4k people
Download Now!
Learn
View all
Membership not found