select by attribute LIKE another attribute value

LJackson29

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!

DavidPike

Bit of a stumper actually, I might just add a new field and run a field calculator expression on it to return 0 or 1 or something like that. then select by attributes where the new field = 1.

#pre-logic python

def checker(PIN, PIN_TRACKING):

   if PIN IN PIN_TRACKING.split(","):

       result = '1'

   else:

       result = '0'

   return result

#window

checker(!PIN!, !PIN_TRACKING!)