Hi<BR>I have a dump from a text file into my table from which I then extract certain columns to display. The amount column though has many zeros preceding the actual number. Like so:<BR>0000001245<BR>0000011255<BR>0000000980<BR>. .....<BR>Any suggestions how to filter off the zeros and get the amount so<BR>the 1st one would be<BR>$12.45<BR>$112.55<BR>$9.80<BR>......<BR>I know to do only for fixed numbers of zeroes and am stumped here. Thanks for the help. Crystal.