>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

Looks like you missed (typo?) 1 as the second parameter.

But they are not entirely equavalent.

refpartno = "@*"
=MESSAGEBOX(SUBSTR(RefPartNo,1,AT('@',RefPartNo)-1))
=MESSAGEBOX(GETWORDNUM(RefPartNO,1,'@+'))

In other words, when the RefPartNo starts with @ you would not get the same result.