Refactoring Databases - Evolutionary Database Design

Consolidate Conditional Expression

Combine sequence of conditional tests into a single conditional expression and extract it.



More on refactoring.com

For more information see page 283 of Database Refactoring