Trapping for characters in a number field

[bxm]

Hi, I have a FM5.5 question.

I have a field defined as a numeric with an auto-enter serial number to keep track of transactions. I also allow the user to override the entered number in case a transaction requires more that one record. In which case they add an alphabetic character to the end of the number ie: 12345B. They prefer to keep the number and alphabetic suffix in the same field rather than in seperate fields.

What is the best way to trap for these alphavetic suffixes entered in the numeric field?

[John Mark Osborne]

What do you mean when you ask about the best way to trap for suffixes in a numeric field? What do you want to trap? Can you be more specific.

Also, are you using this serial number as a primary key for a relationship?

[bxm]

By trap, I mean, if I want to find the reference numbers with the alphabetic suffix so I can run conditional scripts based on this property.

Adn, yes, the reference numbers are a primary key.