SQL statement for sorting, but ignoring the word "The"

Anyone got any clues on SQL statement for sorting, but ignoring the word “The”.

i.e

I have a list:

  • Abracadabra
  • Bananas
  • Simsalabim
  • The Apples

and want it to sort alphabetically ignoring the word “THE” so… it should sort like:

  • Abracadabra
  • The Apples
  • Bananas
  • Simsalabim

and just to make this more interesting, it’s gotta work with Access (microsoft)

Any ideas?

cheers in adv.