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.