DSXchange

Posted: **Thu Aug 20, 2009 10:34 am**

How do I get last 7 digits of a given number.
For ex: 1234567892
I need only last 7 digits 4567892

Thanks

Posted: **Thu Aug 20, 2009 10:50 am**

Right(ColumnName,7)

Column format