Comparision in SQl Server

[Uma Kameswari]

Hi, I have two tables A and B. A have a column col1 with list of values comma separated. B also has a column col2 with list of values comma separated. Now I should get records joining on both the columns where values in col1 = values in col2 all the values should match.How can I achieve this. For example. table A col1 delhi,chennai,kolkata,mumbai delhi,mumbai delhi,chennai table B col2 delhi,mumbai now i want to get all the records from table A where ever the column col1 has both delhi and mumbai this is my problem. Regards, Uma

[gskumar111]

SELECT TABLEA.COL1,TABLEB.COL2 FROM TABLEA INNERJOIN TABLEB ON TABLEA.COL1 = TABLEB.COL2

[Girish481]

Try this: select b.col2 from tableA a,tableB b where BINARY_CHECKSUM(a.col1) = BINARY_CHECKSUM(b.col2) Girish Kumar Sharma