I have a following dataset A id date code 19075F106 4/29/2014 a10,axau10,a1010,axau1010 6219640 4/29/2014 n10,v10,x10,w10,n1010,v1010,x1010,w1010 6366007 4/29/2014 s10,v10,s1010,v1010 B63FY34 4/29/2014 a10,axau10,a1010,axau1010 25179M103 4/29/2014 a10,axau10,a1010,axau1010 Another dataset B date code 4/29/2014 a10 4/29/2014 a10 4/29/2014 a10 4/29/2014 x1010 4/29/2014 w10 I would like to filter dataset A where the code is contained in dataset B. The resulting dataset should be the below. I am trying to use SQL contains but its not working. Thanks for your help! id date code newcode 19075F106 4/29/2014 a10,axau10,a1010,axau1010 a10 6219640 4/29/2014 n10,v10,x10,w10,n1010,v1010,x1010,w1010 x1010, w10 B63FY34 4/29/2014 a10,axau10,a1010,axau1010 a10 25179M103 4/29/2014 a10,axau10,a1010,axau1010 a10
... View more