>The only difference will be when there's no '@' or '+' in the RefPartNo. The old code will blank field out, the new one will leave it as is.

Thanks for taking the time to respond. Actually, I think the last part of the IIF() statement leaves the field as is, rather than blanking it out. Looks as if I can change safely.
>
>>I came across this code

>>REPLACE ALL RefPartNo WITH IIF('@' $ RefPartNo, SUBSTR(RefPartNo,1,AT('@',RefPartNo)-1), RefPartNo)  IN 'zUniqs'
>>REPLACE ALL RefPartNo WITH IIF('+' $ RefPartNo, SUBSTR(RefPartNo,1,AT('+',RefPartNo)-1), RefPartNo)  IN 'zUniqs'

>>
>>and am wondering if

>>REPLACE ALL RefPartNo WITH GETWORDNUM(RefPartNo,'@+') IN 'zUniqs'

>>really is the equivalent expression I think it is. I wasn't able to find a difference, but I may not have tested all conditions and am looking for reassurance.
>>
>>Thanks.......Rich