Thanks Brian but I need an automated way of do it and I don't want to charge
the original contents of the "Job Title" field.

Has anyone used field formulas to do something similar?

"Brian Tillman" wrote:

SoBe wrote:

Judy,

Thank you for your reply, however, it is still an alpha sort. As
metioned in my originaL post, I want to sort my a custum ranking not
alpha i.e.
CEO 1
EVP 2
SVP 3
and so on.

Make your Field values read "1 CEO", "2 "EVP", and so on.
--
Brian Tillman