SELECT ID,
(CASE WHEN tj = 2 THEN '--' + FolderName WHEN tj = 3 THEN '---' + foldername ELSE foldername
END) AS new_foldername, TS, TN, TJ
FROM KS_Class
(CASE WHEN tj = 2 THEN '--' + FolderName WHEN tj = 3 THEN '---' + foldername ELSE foldername
END) AS new_foldername, TS, TN, TJ
FROM KS_Class