Sorting Records Alphabetically, but skipping the word "the"
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.
I'm using Filemaker Pro 9.