I just found out that the number set: (001,002,003,005,006,007,008,009,5,6)
wrecks most of the solutions. It was because SQL was sorting a way that included the zeros in the sort so the sort would come out looking like the above. I didn't notice what was causing the problem until I scrolled way down the list and saw the numbers without the zeros in front of them. On Wed, Dec 22, 2010 at 11:17 AM, william humphrey < b...@bluewatermaritime.com> wrote: > Ken that is too easy and simple. Even I can understand it at a glance. > Can't possibly work. Thanks everyone for lots of excellent answers! -- http://www.bluewatermaritime.com _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
