Updating records by removing leading '00's from account numbers (int)???

• davidsalazar01

  SSCarpal Tunnel

  Points: 4072

  More actions

  January 11, 2010 at 8:26 pm

  #137201

  All,

  What's the best way to update thousands of records to remove leading '00's from account numbers (int)?

  The account numbers would be in the following format:

  - Any 10 digit account number that begins with two zeros (ie. 0026698056).

  Please advise and Thanks!

  -David 😉

• arun.sas

  SSChampion

  Points: 11831

  More actions

  January 11, 2010 at 9:04 pm

  #1102159

  Hi,

  Repeated post, discussion already started here

  http://www.sqlservercentral.com/Forums/Topic845782-338-1.aspx