<googlegroups@sbcglobal.net> wrote in message
news:1154386491.808557.253670@b28g2000cwb.googlegroups.com...
> Not sure if this is the right group or not be I figured I would pose
> the question here to see if I could generate some feedback.
>
> Say I have a table (Employee) with one text column (Resume) that stores
> your employees Resume and another table (EmployeeJobs) with one text
> column (JobDescription) that contains a job description for job
> opportunities within your company.
>
> There is a one to many relations from Employee to EmployeeJobs.
>
> How would you approach matching the Resume column to the JobDescription
> to see which Job Description is the best match for an employee's
> resume.
>
> I have gone around with using full text but have come to the conclusion
> that I may be spinning my wheels in that arena.
>
> What I have finally come up with is keyword searching the Resume column
> and JobDescription column and try to determine which best matches based
> on a keyword set.
>
> Any other ideas or approaches???
>
> FYI..why am I doing this? My company is the midst of an acquisition
> (rather large) and HR is trying to determine how to best fit an
> individual to an opening.
>
> Nuts???? I think so...
>