2. PHPRunner General questions
  3. Non-Standard Alphabetizing
This topic is locked

Non-Standard Alphabetizing

 		10/31/2007 8:40:06 AM
PHPRunner General questions
S
 SteveOH author

I'm working on making a database that lists the names of buildings in my region. Some of the buildings official names start with "The" others do not. Is it possible to have the standard Alphabetizing Sort ignore the first word if it is "The"?
For example:
The Sparta Municipal Building

Sparta Theater

The Sparta Zoo
hfg 10/31/2007

My solution to this in a similar project is to add a new field I called "Alpha" (or something like that). You then put the name of building (in your case) without the The in. You then use this field for sorting, but don't display it in the field itself.
The biggest draw back to this is your users can't use it to resort later (they have to leave the list and come back).
Not a perfect solution, but it gets the job done.