how to update set some added string

[MATTXtwo]

i have tblPeribadi as table of database
i want to add some string to each row for column kod_pusat_kos
maybe like this..

UPDATE tblPeribadi SET Kod_Pusat_Kos='00'+Kod_Pusat_Kos WHERE Kod_Pusat_Kos>10000001

[ck9663]

what's the data type of kod_pusat_kos ?


-- CK

[MATTXtwo]

kod_pusat_kos char(10)

[amitpatel66]

Yes you can concatenate the data to the existing value of the column but that should not exceed 10 Characters

[ck9663]

If you're considering of left-padding your column with zeros, consider this:

UPDATE tblPeribadi 
SET Kod_Pusat_Kos=right('0000000000'+Kod_Pusat_Kos,10)
WHERE cast(Kod_Pusat_Kos as int) >10000001

Happy coding!

-- CK

[MATTXtwo]

If you're considering of left-padding your column with zeros, consider this:

UPDATE tblPeribadi 
SET Kod_Pusat_Kos=right('0000000000'+Kod_Pusat_Kos,10)
WHERE cast(Kod_Pusat_Kos as int) >10000001

Happy coding!

-- CK

Thanks CK and i did it with LEFT