Can you define a custom less-than operator for sorting? If this were C++, I'd do std::sort(Result.begin(), Results.end(), MyCustomOperator());
- Sherief > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:sqlite-users- > [EMAIL PROTECTED] On Behalf Of Andrew Gatt > Sent: Wednesday, July 23, 2008 9:41 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Ignoring "The" > > > >> 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users