Declare @Degree Varchar(20) = '11'Update [SRO_VT_SHARD].[dbo].[_RefObjCommon] Set Rarity = 255 Where CodeName128 Like '%' + @Degree + '%_RARE'