If you are on 2017 or later you can use CONCAT_WS:
Select Id
, name
, concat_ws(',', Mon, Tue, Wed, Thu, Fri, Sat, Sun)
From employee
If you are on 2017 or later you can use CONCAT_WS:
Select Id
, name
, concat_ws(',', Mon, Tue, Wed, Thu, Fri, Sat, Sun)
From employee