If you need to include description and the valid column you would just need to add it into values list:

insert into table (ssn,empid,race,description,valid)

values (

@ssn,

@empid,

@Race,

@description,

CASE @description

WHEN 'deputy' THEN 'Y'

WHEN 'civilian' THEN 'N'

end

)

It shouldn't hurt anything to do that. Valid is a column in the same table right?

Hope to help,

Dane