case statements?

a Stored Procedure?