Thread

A, An, and The, out of Alphabetical order

Richard Lynch <lynch@lscorp.com> — 1998-07-05T04:21:23Z

I probably need a whole new column for alphabetical ordering, but...

I want something like this for now (I think):

select band, ltrim(band, 'THE ') as alpha from bands order by alpha;

except I only want a match on 'THE ', not any any character within it,
which is what ltrim does...

Is there something like what I want that's easy to do?
[If it's way hard, I'll just add a column.]

--
--
-- "TANSTAAFL" Rich lynch@lscorp.com