update [Medicare].[dbo].[tbMedPackage] set casetype=0 where PackageID<=30 
go

update [Medicare].[dbo].[tbMedPackage] set casetype=1 where PackageID>30 and PackageID<434
go

update [Medicare].[dbo].[tbMedPackage] set casetype=2 where PackageID>=434
go