[Solved] SQL Change Value + 10000


Try this

UPDATE TPatientRaw 
SET tPatSSlidaID = RIGHT('0000000000' + CAST(CAST(tPatSSlida AS int) + 10000 AS VARCHAR), 10)
WHERE tPatSName="CLINIC DENT"

simple test

4

solved SQL Change Value + 10000