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

**URL:** https://forum.kirupa.com/t/sql-statement-for-sorting-but-ignoring-the-word-the/39263
**Category:** programming
**Created:** [January 5, 2004, 2:38pm UTC](https://forum.kirupa.com/t/sql-statement-for-sorting-but-ignoring-the-word-the/39263 "2004-01-05T14:38:38Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![ratbaggy](https://avatars.discourse-cdn.com/v4/letter/r/a3d4f5/32.png) [@ratbaggy](https://forum.kirupa.com/u/ratbaggy)
#### Post date: [January 5, 2004, 2:38pm UTC](https://forum.kirupa.com/t/sql-statement-for-sorting-but-ignoring-the-word-the/39263/1 "2004-01-05T14:38:38Z")

</div>

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.