如何基于另一列在SQL中为一列设置默认值

I'm working with an old SQL 2000 database and I don't have a whole lot of SQL experience under my belt. When a new row is added to one of my tables I need to assign a default time value based off of a column for work category.I'm working with an old SQL 2000 database and I