如何比较SQL Server中的字符串数据与表数据 - 我需要知道列中的字符串中是否存在值

I have two tables, one an import table, the other a FK constraint on the table the import table will eventually be put into. In the import table a user can provide a list of semicolon separated values that correspond to values in the 2nd table. I have two tables, one an import table, the oth