>Larry,
>
>While I agree that EMPTY() is not optinmizable, if I leave the
>"<> SPACE(10)" in there, and the field size is modified, then it
>might not work at all, so in this case, I think it's better to use
>the NOT EMPTY()
Change it to space(len(fieldname)) or build a variable prior to the replace using these functions.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao