I process data from a legacy system with SSIS before importing data into a SQL Server 2008 db.
A currency field is so formatted:

```
000000xxx.xx

```

I need to remove the leading zeros. Note that the actual currency value has not a fixed number of digit. So, for instance, it could be xxxxx.xx or x.xx or xxxxxxxxxxx.xx

I found this [answer](https://stackoverflow.com/questions/2457603/algorithms-to-trim-leading-zeroes-from-a-sql-field), but the derived column tool display only limited string functions, like the Access formula wizard.

So my question:

* how may I use PATINDEX in the DTS derived column tool
* otherwise, how may I remove leading zeros from input column