If I have values after the case statement what would it look like?

I'm not sure of the syntax. Also I don't have the columns hardcoded on the insert line because I'm putting data into all of them.

insert into table

values (

@ssn,

@empid,

@Race,

@description,

CASE @description

WHEN 'deputy' THEN 'Y'

WHEN 'civilian' THEN 'N'

end,

column1,

column2,

)