I fixed it by checking to make sure every number was formatted as three
characters first. It's funny what you don't see...

On Sun, Dec 26, 2010 at 2:34 PM, william humphrey <
b...@bluewatermaritime.com> wrote:

> 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
>



-- 
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

Reply via email to