Assuming the second word IS the last name, sort index1 by word 2 of each
or sort index1 by last word of each which will allow you to have middle names. The caveat to this approach is that people who have multiple words in their last name will have to be entered without spaces. Sometimes people get really picky about that. So Betty Jane Smith Ross would have to become Betty Jane Smith-Ross and who cares if she doesn't like it like that! :-) Bob On Jun 13, 2012, at 2:23 PM, Mark Rauterkus wrote: > Hi, > > Now to sorting the results of the navigation field. > > > Working: > > sort index1 > > Perfect, except, and the names come back in the results posted as > expected by the person's First_Name Last_Name. > > But, how does one sort so that the Second_Name is in A-Z order? > > My broken attempt: > > sort second word of index1 > > And, I guess index1 is just a temp container and not an array. Right? > > > -- > Ta. > > > Mark Rauterkus mark.rauter...@gmail.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 _______________________________________________ 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
