Is there a better way of branching other that this:

VB Code:
  1. DECLARE @Type INT

  2. SET @Type = 2

  3.  
  4. If @Type = 1

  5.     PRINT 'Number 1'

  6. If @Type = 2

  7.     PRINT 'Number 2'

  8. If @Type = 3

  9.     PRINT 'Number 3'

  10. If @Type = 4

  11.     PRINT 'Number 4'

I need this to work on the following db: MS SQL 7.0, MS SQL 2000, MS SQL 2K5 and possibly MySQL 4.1.

Thanks!