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 |
|
kp1279
Starting Member
1 Post |
 Posted - 2005-12-29 : 05:19:28
|
I am very new to SQL and Access projects.I have created the full text catalogs for my tables, so that I can search all the tables at the same time, from any of the fields in the catalogs.I have created the following procedure:-create procedure usp_full_text(@findtext varchar(255))asselect set_id as URN, input_date as date_of_record from set_records where freetext (*, @findtext)There are a few union selects under this, butIf I search for perhapse 'SMITH' from within access, then this will bring back all the records which have smith in them somewhere, which is good, however if I repeat the search for 'smit' then I get no records returned.How can I change the code to find the parts of words, or string of charactors, and how can I set this to do a soundex search?Hopefully all this is possible, i just need pointers on how to achieve this, or I could be sat there for days.Many thanks for any help you can offer. |
|
|
FruitBatInShades
Yak Posting Veteran
51 Posts |
Posted - 2006-01-25 : 03:54:07
|
| I have exactly the same problem! THe index does not appear to be populating, I just upgraded to SP4 in the hope it would sort the problem out but no luck :( Did you ever find an answer? |
 |
|
|
|
|
|
|
|
PROBLEMS WITH FULL TEXT SEARCHING