When the range of numbers is known _ say $ for a Supplier PO _ if 8 characters is allowed for the $ amount _ add $100 000 000 _ convert to a string _ and use the RIGHT(@Amountt, 8).