
@Rasagna Sir, below are some of the ways to do so
DECLARE @Details table(Name VARCHAR(10),Category BIT)
INSERT @Details VALUES('Name1',1),('Name2',1),('Name3',0),('Name4',1),('Name5',0)
--Way 1 : Using Case statement
SELECT
Name
,Category
,NewCategory = CASE WHEN Category = 1 THEN 'cat-x' ELSE 'cat-y' END
FROM @Details
--Way 2: Using IIF function
SELECT
Name
,Category
,NewCategory = IIF(Category = 1,'cat-x','cat-y')
FROM @Details
-- Way 3: Using Choose function
SELECT
Name
,Category
,NewCategory = CHOOSE(CASE WHEN Category = 1 THEN 1 ELSE 2 END,'cat-x','cat-y')
FROM @Details
In all the above case the result will be
Name Category NewCategory
Name1 1 cat-x
Name2 1 cat-x
Name3 0 cat-y
Name4 1 cat-x
Name5 0 cat-y
Hope that helps.
--
Thanks & Regards,
RNA Team
Rasagna, if this helps please login to Mark As Answer. | Alert Moderator