USE [SRO_VT_SHARD] GO Declare @CharName Varchar (64) Set @CharName = 'kira' UPDATE [dbo].[_CharSkillMastery] SET Level= 120 WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)