Post
Ask Question

Select Null Values and Concatenate with String Values in SQL Server

Suppose we want to concatenate first_name,middle_name,last_name but these columns also contains null values like: 
  1. select first_name,middle_name,last_name, father_name,emergency_contact_no from sis_student_details    
 

And we want a output like this:
 
 

Then we rewrite the query like this: 
  1. select (first_name +ISNULL(middle_name, ' ')+ISNULL(last_name,'')) as Name,  
  2. father_name as [Father Name],emergency_contact_no as[Contact No.]  
  3. from sis_student_details  
This query will concatenate null values with string.