AnsweredAssumed Answered

Sorting Records Alphabetically, but skipping the word "the"

Question asked by MattSchuurman on Dec 18, 2012
Latest reply on Dec 18, 2012 by MattSchuurman

Title

Sorting Records Alphabetically, but skipping the word "the"

Post

     I would like to sort all the records in my database alphabetically, by name. Easy enough, except that some of record names begin with the word "The". When sorted, I would like all records that begin with "The" to be sorted by the next word in the name.

     For example: If there is a record named "The Coliseum", the order should look like this - Capital Centre, The Coliseum, Dover Place, etc. NOT - Texas Arena, The Coliseum, Theatre Hall, etc.

     Help?

     I'm using Filemaker Pro 9.

Outcomes