"Sean" <SeanNotLikeSpam@fakeisp.net> wrote in message
news:BCCFAD3C-A65E-4DB7-B307-15969DE11E3F@news.elevatesoft.com...
>
> Index the table by the key you are looking for. Start at the first record
> & get your first distinct value.

Thinking down them roads great minds and all

>Do what you want with it. Change the last character in the distinct value
>to the next ordinal value. For example, 'Jones' would become 'Jonet'. Do a
>find nearest on this value to get the next distinct key value. Repeat until
>no more are found. Probably not necessary for text data, but you could be
>safe and check for a string ending in a character 127 or 255 and in that
>case append a CHR(1) instead of changing the last character.

Sean thats oneway but now my grey cells are thinking on overtime and
a logical field true for the 1st distinct of each name and false thereafter
would be a breeze really thanks for that kick in the rear.
Rita

Rita

>Sean thats oneway but now my grey cells are thinking on overtime and
>a logical field true for the 1st distinct of each name and false thereafter
>would be a breeze really thanks for that kick in the rear.

Or maintain a separate table of unique names. Even faster for lookup

Roy Lambert [Team Elevate]