Saturday, June 9, 2012

REPLICATE

 You can fix the character length by using below

UPDATE HS_HR_CORPORATE_TITLE_NEPAL
SET CT_CODE = REPLICATE ('0',6- LEN (CT_CODE + 306)) + CAST ((CT_CODE + 306) AS VARCHAR)

No comments:

Post a Comment