how to replace the null value with space while fetching the data from database.
below i given my code.
//sql query
select r.login_id,r.First_Name,r.Email_Id,e.industry_type,'<b>Name-</b>'+r.First_Name+'<br>'+r.Email_Id +'<br>'+'<b>IndustryType-</b>'+e.industry_type as fulldetails
from Registration as r
inner join Experience_Detail as e
on r.Login_Id=e.Login_Id and status='Active' and Designation='User'
//in this e.industry_type field having null values
when i am binding the data of all the fields into one field as fulldetails.if there is null value in any field means fulldetails is showing null values for example you can see below.
login_id| First_Name | Email_Id | industry_type | fulldetails
-----------------------------------------------------------------------------------
nitish | nitish |pv@gmail.com | IT | nitish,nitish,pv@gmail.com,IT
teja | teja |pv@gmail.com | null |null
//But i want the table like this below,for that what i have to do.
<pre lang="vb">| First_Name | Email_Id | industry_type | fulldetails
-----------------------------------------------------------------------------------
nitish | nitish |pv@gmail.com | IT | nitish,nitish,pv@gmail.com,IT
teja | teja |pv@gmail.com | null |teja,teja,pv@gmail.com,</pre>