How do I in Crystal 10

[grad74sfp]

Using CRYSTAL 10.

A field titled INVOICE NUMBER always has *0000000 at the end. These are extraneous characters I do not need on the report. How do I remove them from the Invoice Number field. The field length is 25; and, again, I do not need the last eight characters.

[sraheem]

If it is a character field then u can use SQL expression , and builtin function substring.