> Hi Stéphane,>> to_number works in the same fashion as in oracle. You need to give> to_number('<yourdata>','formatmask')> For example, to_number('1234567','FM9999999')>> Regards,> Gautham.
Thanks a lot ! That works !!