How to update the Field by Remove Leading Zeroes in Entire table
518282Jun 14 2006 — edited Jun 14 2006Hi all,
I need an SQL query to update the Table by upadating a particular field(column) by removing all the leading zeroes for all the rows corresponding to that column.
Ex:;
Existing To be changed to::(New Table)
A B New A New B
000011 1 11 1
000012 2 12 2
000013 3 13 3
Thanks in Advance,
plz do reply soon..