SELECT CAST(USER_ID As Varchar) + '--' + NAME + '(' +
CASE
	WHEN ACTIVE= 1 THEN 'ACTIVE'
	ELSE 'INACTIVE'
END
+ ')' As NRICNAME
FROM M_USER