select Top 1
COALESCE(CONVERT(VARCHAR,datetest.ID),'blank')+'#'+
COALESCE(Name,'blank')+'#'+
COALESCE(loc,'blank')+'#'+
COALESCE(convert(varchar,joindate),'blank')+'#'+
COALESCE(case when convert(varchar,active)=1 then 'true' else 'false' end,'blank')
from tbl_emp
This is working perfectly