 <p>i got the answer it is simple logic.. <code>add commas within the ISNULL() function</code></p> <pre><code>select Name+isnull(','+Address1,'')+isnull(','+Address2,'') as compDeatils from tableCompany where ID = 4 </code></pre> <p><strong>Note</strong>: Name will not give <code>NULL</code> in my case. in case name also null this answer is not applicable.</p>