Try this
UPDATE TPatientRaw
SET tPatSSlidaID = RIGHT('0000000000' + CAST(CAST(tPatSSlida AS int) + 10000 AS VARCHAR), 10)
WHERE tPatSName="CLINIC DENT"
4
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"
4
solved SQL Change Value + 10000