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 Davepike101@hotmail.com

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:

 

PIN_TRACKING LIKE '%PIN%'

 

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!

Outcomes