Creating ordered lists that ignore the word 'The' at the start of phrases

[m.k.ball]

What is the best way to achieve alphabetically ordered lists that will
index phrases starting with 'The' as if the word was at the end rather
than the start of the phrase?

Michael

[Rich Ryan]

CREATE TABLE Titles(
Title varchar(100));

INSERT INTO TITLES VALUES('The World According to
Garp'),('Casablanca'),('The Day After Tomorrow');

SELECT
CASE
WHEN SUBSTRING(Title,1,4) = 'The '
THEN CONCAT(SUBSTRING(Title,5,LENGTH(Title) - 4),',The')
ELSE Title
END as T
FROM
Titles
ORDER BY T ASC

Rich
<m.******@btinternet.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

What is the best way to achieve alphabetically ordered lists that will
index phrases starting with 'The' as if the word was at the end rather
than the start of the phrase?

Michael