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.
| Author |
Topic |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2008-07-20 : 23:34:40
|
| Hello All,I’m storing resumes in a memo field in my database, and I would like to know what would be the best way to find the closet match. Example: Lets say I’m looking for a candidate that has the closet to the below required/desired items:- Bachelor degree Required- Cisco Router Troubleshooting Required - Routing Protocols (BGP, EIGRP, OSPF) Required - CSU, MUXES Required - IP Voice Desired - Data Circuit troubleshooting Required - Frame-Relay, T3, T1.5. MPLS Desired - CCNP Desired - CVoice Desired Does anyone know how to write a query for these search criteria? Advice would be appreciated. Thanks. |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2008-07-20 : 23:48:16
|
| Have a look in Books Online for the PATINDEX function.The tricky bit is determining your search criteria to pick all the matches up.A better solution (although more work for data entry) is to have a reference list of all skills you look for (coffee making, car washing, brown nosing etc) and tag each candidate's record accordingly. Make the recruiters earn their money.... :-)Cheers,Tim |
 |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-07-21 : 01:18:15
|
| You could also have a look at the soundex function |
|
|
|
|
|
|
How to find the closest match in a memo search?