• Adding Zeros to a column

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

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