I need to be able to extract part of a field to use in a crystal report. For example: my account # is any number of digits with a - followed by another number. I just want the numbers in front of the -. If the account = 1234-1 i want it to return 1234. if the accoutn = 123-23 i want 123. How can i do that?