Short and easy to follow but N is not always numeric.
You can add a regular old variable to hold all of the prefixes, use a LOCATE() to find the field number of the prefix and then use that to access the array N. Going through all this, might just make the I-Type the way to go. How often do you expect to have to do this sort? Is it something that will run in a batch or is it a request that a user will be sitting there waiting for a response?
Ray -- .=================================================================. | =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= | | -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- | | <http://www.eriscorp.com> <mailto:[EMAIL PROTECTED]> | |Midwest Regional Office: 815-547-0662 (voice) 503-905-8153 (eFax)| .=================================================================. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
