asked on

SQL Select - String match option

Is it possible to have SQL Select that can compare words in string column from one file to another? I need a SQL statement that can tell me the number of words that match between tow files.

For example; Let's say I have two files each contain one column containing a string of words.

File 1 - MatchString
Consumer Credit Report
Commerical Credit Report
FICO Score and Income Report
Commerical Assest and Income Report

File 2 - MatchString
Credit Report Category
Credit Score Category
Asset Category

Expected Results
Source File      Match-Field1      Match-Field2        Match Word Count
MatchFile1      Consumer Credit Report
MatchFile2 Credit Report Category        2

MatchFile1      Commerical Credit Report
MatchFile2 Credit Report Category        1
MatchFile2 Credit Score Category        1

MatchFile1      FICO Score and Income Report
MatchFile2      Credit Score Category        1

MatchFile1      Commerical Assest and Income Report
MatchFile2      N/A        0

ASKER CERTIFIED SOLUTION

chaau

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Vitor Montalvão

Do you really mean files or should be tables?
Because if it is really files you have better options than SQL Server to do the job.