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..

Expand|Select|Wrap|Line Numbers

 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:

Expand|Select|Wrap|Line Numbers

  
UPDATE tblPeribadi 

SET Kod_Pusat_Kos=right('0000000000'+Kod_Pusat_Kos,10)

WHERE cast(Kod_Pusat_Kos as int) >10000001

Happy coding!

-- CK

MATTXtwo

Quote:

Originally Posted by ck9663

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

Expand|Select|Wrap|Line Numbers

  
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

re: how to update set some added string