> In SQLite these can be combined into one query that gets the desired rows. > > select * from mytable where Name >= ( > select Name from mytable where Name < 'Sprenkle' order by Name > desc limit 1 offset 50) > order by Name limit 101; > > This query works as expected in SQLite so it should be a work around for > your union bug.
That's pretty elegant. Nicely done! > P.S. And now 'Sprenkle' has been raised to the same heights as 'foo' and > 'bar'. LOL! I've been told I'm 'fubar' but hey, I've gotta work with what I have.