ignore the when sorting alphabetically
open
low
Common problem when dealing with names of things that often begin with "the". Maybe "a" as well?
Related support tickets:Relevant user stories:add oneTags:
Just do it, or offer a setting?
see http://stackoverflow.com/questions/3252577/how-to-sort-in-sql-ignoring-articles-the-a-an-etc
--Ethan McCutchen.....Thu Mar 10 17:01:45 -0800 2011
just want to note that this is going to be more hard-coded english.
--Ethan McCutchen.....Sun Apr 17 11:56:19 -0700 2011
tried that solution and reverted. trim doesn't treat those like strings but like characters -- no dice.
--Ethan McCutchen.....Fri May 06 22:18:39 -0700 2011
Notes