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.

>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