Issue with contains function

geeksqaud

i am trying to compare 2 fields. not sure what i am missing but i am not getting the correct result.

if Contains([Field2], ([Field1])) then 'YES' ELSE 'NO' ENDIF

Field1          Field2                                                              RESULT
114627       114627@74945@@97564@@@@@@@@@                   YES
11                  1@2@0                                                                   NO
6                   6560@752925@823142@629206@644744           YES

Appreciate your help!!!!

Ticket.PNG

caltang

Sorry @geeksqaud just read your new comments. Like so?

For geek.yxmd