How to create a.net equivalent function in SQL server

See more:

C#

ASP.NET

SQL-Server

Hello,

I want to create a .net equivalent function in sql server. .Net function is as follows

private string getEligibility(int? elig, string overridden)
        {
            string ret = elig == 0 ? "Red" : elig == 1 ? "Green" : elig == 2 ? "Yellow" : elig == 3 ? "Purple" : elig == 4 ? "P" : elig == 5 ? "NA" : elig == 6 ? "PB" : elig == 7 ? "EX" : elig == 8 ? "PA" : elig.ToString();
            if (!string.IsNullOrEmpty(overridden) && overridden == "Y")
            {
                ret += "^";
            }
            return ret;
        }

Same like above I need to create in sql server.
I have tried as below but only getting eligibility. I also need to check its overridden value and then need to return final value. Bold part of .net code I am not able to write in sql server.

What I have tried:

create function [dbo].[udfgetEligibility]
(
@eligibilty as int
)
RETURNS varchar (100)

as
begin
return CASE
WHEN @eligibilty = 0 THEN 'RED'
WHEN @eligibilty = 1 THEN 'GREEN'
WHEN @eligibilty = 2 then 'YELLOW'
WHEN @eligibilty = 3 then 'Purple'
WHEN @eligibilty = 4 then 'P'
WHEN @eligibilty = 5 then 'NA'
WHEN @eligibilty = 6 then 'PB'
WHEN @eligibilty = 7 then 'EX'
WHEN @eligibilty = 8 then 'PA'
-- etc...
ELSE CONVERT(varchar(10), @eligibilty)
end
end