Hey everyone, I have another formatting question.

I have a file that is FTPed to me daily. I use SQLLOADER to insert the data into an Oracle database. The problem is the fields are isnerted by fix width. That means that the field that contains the numbers I have are out of wacked. Here is that I need:

The number coming out of the DB is 000025000

I need to cut the leading zeros off, any help?

Thansk again...