[ad_1]
Try this
UPDATE TPatientRaw
SET tPatSSlidaID = RIGHT('0000000000' + CAST(CAST(tPatSSlida AS int) + 10000 AS VARCHAR), 10)
WHERE tPatSName="CLINIC DENT"
4
[ad_2]
solved SQL Change Value + 10000
[ad_1]
Try this
UPDATE TPatientRaw
SET tPatSSlidaID = RIGHT('0000000000' + CAST(CAST(tPatSSlida AS int) + 10000 AS VARCHAR), 10)
WHERE tPatSName="CLINIC DENT"
4
[ad_2]
solved SQL Change Value + 10000