omit word in entry for alphabetical order

[airhud86]

Im trying to create a DB of all the movies I have and many of them obviously start with "The". Is there anyway to omit "The" so the alphabetical order will be correct???



Thanks in advance,

Phil

[NTC]

make two columns:
alpha sort name
formal name

and then sort by the alpha sort name - but display the formal name....