>> I have a table of music artist names which i'd like to output in order. >> Normally i just use: >> >> select * from artists order by artist_name; >> >> What i'd really like to do is order the artists by name but ignore any >> "the" or "the," preceding it. >> >> Any ideas? >> >> Thanks >> >> Andrew >> >> > Store it like "Beatles, The" them make the transformation latter, if > necessary? > > That's one idea. > > Best, > Daniel > > Thanks for the reply, I may be able to use this approach in future. But there are already many entries in the table and so an SQL statement that does it for me would be good!
Andrew _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
