Adding Zeros to a column

Posted: November 20th, 2009 ˑ Filled under: SQL ˑ  No Comments

UPDATE Industry_Mines
SET AFM = RIGHT(REPLICATE(’0′, 9) + CONVERT(VARCHAR, AFM), 9)