Hi all,

can anyone please help me with a derived column that transforms a CASE statement?

CASE
WHEN [MAIN_GAME] IS NULL AND combo.[CAT_PRODUCT] ='25' THEN 'Standalone'
WHEN [MAIN_GAME] IS NULL AND combo.[CAT_PRODUCT] <> '25' THEN 'No main game'
ELSE LOWER(prod.[TX_PRODUCT_NAME])
END AS [TX_MAIN_GAME]

Thanks in advance!

CAT_MAIN_GAME = nvarchar(6)

FK_GAME = nvarchar(2)

• Edited by Yvanlathem 48 minutes ago

I can do the first part 

ISNULL([MAIN_GAME]) &&  (DT_I4) [FK_GAME] == 25 ? "Standalone" : "REST QUERY"

But I cannot get the rest in my query