query help to solve problem

• pat-261672

  Hall of Fame

  Points: 3325

  More actions

  May 14, 2008 at 4:27 pm

  #380519

  I want to select all rows from table 'relatives' where column 'relative' contains any substring that matches any member of a list of strings returned by the query (SELECT [name]FROM [relativegroup] where nodes like '%ALOHA%'

  how can i do that?

  Thanks

  Pat

• John Beggs

  SSCommitted

  Points: 1921

  More actions

  May 14, 2008 at 4:50 pm

  #815575

  Performance might prove interesting, but this is an option:

  SELECT R.Relative

  FROM Relatives R, RelativeGroup RG

  WHERE RG.Nodes LIKE '%ALOHA%'

  AND R.Relative LIKE ('%' + RG.[Name] + '%')

  I can't make a good performance test on it at the moment, but it's a starting point.