Hi,

I have a varchar column from source table that might have leading zeroes.

I need to strip the zeroes and insert/update to target.

I see that we can use TRIMV, but being a newbie in DM, bit confusing how to use it.

help !!!

Thanks much for your help

This message has been edited. Last edited by: Kerry,

Wow, figured it !!!

using TRIM we can remove leading characters not just spaces works fine ..

physician heal thyself!

T