• this is my next try,

    set @id1 = 60

    select coalesce(cast(@id1 as varchar(10)),'') + ',' + coalesce(cast(@id1 as varchar(10)),'') + ',' +

    coalesce(cast(@id1 as varchar(10)),'')

    it gives the result as 60,,

    I don't want the ,,. because it it has value result with comma. if it doesn't, no need to append comma

    Any help please