AnsweredAssumed Answered

select by attribute LIKE another attribute value

Question asked by jacksonl_NEORSD on Jun 16, 2020
Latest reply on Jun 16, 2020 by

I want to use Select by Attribute to select records where the value in one attribute is LIKE the value in another attribute, so for example:




Where PIN_TRACKING is a list of PINs and I want to identify if PIN is listed in PIN_TRACKING


PIN           PIN_Tracking

1               1,2,3

2               4,5

3               1,2,3


So for the above data it would select record 1 and 3 as the PIN is included in the list in PIN_TRACKING


Thanks for your help!