/****** Seperate with Comma in DB ************/

select substring (( select ', ' + JRNo from JnMBJobSp where LedNo='JNMB3575' FOR XML path('')), 2,500) as JRNo