>>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) >>>>NOT TESTED!