Results 1 to 23 of 23
Mar 8, 2012, 01:23 #1
- Join Date
- Feb 2005
- from Madrid to Heaven
- 199 Post(s)
- 1 Thread(s)
Query issue... Selecting values that include any of the words from a list
Hi SQL experts! Need some help here
I have a database that lists the software installed in each computer in my company, and on the other side I have a list of software and the number of the version compatible with win 7
I have to cross the data between these two tables. I need to know which software in the first list includes the software listed in the second list.
The first list shows the software installed in various computes, and it will look like
7-Zip 4.65 Igor Pavlov 4.65.00.0 Adobe Acrobat 9 Standard - Italiano, Espaņol, Nederlands, Portuguęs Adobe Systems 9.0.0 Adobe Flash Player 10 ActiveX Adobe Systems, Inc. 10.0.12.36 Adobe Reader 9 - Espaņol Adobe Systems Incorporated 9.0.0 Adobe SVG Viewer 3.0 Adobe Systems, Inc. 3.0 Altiris Application Metering Agent Altiris Inc. 7.0.1255.0 Altiris Inventory Agent Symantec 7.0.1218.0 Broadcom Management Programs Broadcom 7.74.01 Broadcom NetXtreme Ethernet Controller Broadcom 7.51.01 CA Unicenter Software Delivery Computer Associates
Configuration Manager Client Microsoft Corporation 4.00.6487.2000 DWG TrueView Autodesk 184.108.40.206
But on the second list, the sofware looks like
13 AUTOCAD 2010
6.9 DWG TrueView 2010
14 EXCEED OnDEMAND
As you can see, the names of the software in both list don't match. Therefore, I need to do a query that gives as a result the software that includes any of the words from the second list.
My goal is to compare the versions of each software to know if what he has installed will be compatible in his new computer.