>>There're two ways to deal with this problem in general. First is to use PADR() function (not PADL()). It could work if the lenght of the memo is less that 254 characters but in this case memo'll be converted into character field. The second is to select only key fields for unduplicated records using group by and than get memo field by joining back to the source table.
>
>I like the way you think, using only key fields and then joining back. It going to be tricky, since this is a query maker program. That has to be recursive (searching the result query for another condition.) but I think I can pull it off using your idea.
>
>Thanks.
Good luck.
--sb--