ms sql marge two column

Sir I am using following select statment:

select Naration=b.Naration +' Job # : '+ b.File_job from xyz

It is running me return when the both column (naration & File_job) have containts, if the naration have containts and file_job is null then it is showing null. Please help.

Rgd.s
Mehram
MehramAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
SjoerdVerweijConnect With a Mentor Commented:
select Naration=b.Naration +' Job # : '+ coalesce(b.File_job, '?') from xyz
0
All Courses

From novice to tech pro — start learning today.