Number to string conversion

[stoopers]

How can I convert a 10-digit order number to a 6 digit string? The 10-digit number startswith 4-6 zeroes and ends with the order #. (ie. 0000040000 or 000094451 or 0000009499). We need to access the last 6 digits - but need to eliminate all zeroes (ie. order #= 40000, or 94451, or 9499).

We are using iScala and Crystal Reports 11.

Thanks for any help!

 

[synapsevampire]

Try:

val({table.field})

or

totext(val({table.field}),0,"") to keep it as a string field.

-k