>Things look right with the UDFs. You should try taking them out of the SELECT one by one until you find the problem.
>
>You do have a potential problem with
>
>UPPER(TRIM(lastname) + firstname + mi) AS ifield,;
>
>
>The field in the result set will be the length as the first record. You should PADR() the result.
>
Good point, although that field is there only to set the order. I'll try removing them incrementally to see what happens.
Ray Roper