>After reading the documentation I decided against it, instead I’ll modify the design to not allow duplicate records on the table.
>
>It is difficult for me to use the padl() function because this is a query maker program so the field selection will get a lot more complex.
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.
--sb--