>INSERT INTO [Rates]
>           ([rat_pk]
>           ,[rat_name]
>           ,[rat_type])
>     (SELECT newid()
>           ,[SpecialRate]
>           ,[rat_type]
>      FROM (SELECT DISTINCT SpecialRate
>                          ,case when SpecialRate like 'Mail%' 
>                                     then 2
>                           case when SpecialRate like 'ZipX%' 
>                                     then 3
>                           else 1 end AS [rat_type]
>            FROM [Weight Rates-Special Rates]) Test)
>