Are there some command in SQL that is similar to the Select Case in VB?

Thanks.