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