I am trying to change some the format of the data within a table. Here is the example:
I would like to change a series of numbers ( 149 ) to this new format
( 00149 ). Is there a way to do this without going through thousands of records???
Maybe with a query or something??
Thanks for your help,
Marsbar