Sql Substring Trigger Update

create trigger son4RakamiKes on Tablo after insert
as
declare @id int
begin
select @id = ID from inserted -- son insert edilen kayıt
update Tablo set No = SUBSTRING(No, 16, 22) from Tablo where ID = @id
end