Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Comparing tables using like

Author  Topic  Mark Starting Member 48 Posts Posted - 2000-11-16 : 12:50:56 I have 2 tables, each one contains a feild called Desc. I need to create a query that searchs this coloumn in table 1 and return any matches with table 2. for example.. table1.desc contains "SQL, NT" (Its in varchar by the way). Table2.desc contains 4 entries "NT,oracle" "Win95, A+" "A+,sql,nt,oracle,asp" "A+,asp,win98,word" I want the query to search for the word NT in that table or sql (the entry in table1.desc).. so in this case it would return 1 and 3. 1 because it contains NT and 3 because it contains nt and sql