Ignore certain words at the beginning of a title when sorting
I have several databases that use titles of books, poems, videos, etc. that I want to sort without "The," "a," or "an" as the first word. For example, The Wind in the Willows would be sorted in the W's. Is there a way to have FileMaker ignore those words when sorting? I am using 8.5 for Mac.