Home Forums SQL Server 2012 SQL 2012 - General Lookup value from one table based on values in another table RE: Lookup value from one table based on values in another table

  • What exactly do you mean by "contains"? Do you mean something other than "equals" Or do you mean something like

    set {a, b, c} contains {b}?

    How are you determining "contains" in Access? InStr()? IF that's the case, then you would need to split that out into separate records...