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 |
|
dan.white
Starting Member
5 Posts |
 Posted - 2000-09-15 : 10:56:52
|
| objRS.Open "SELECT * FROM contactData WHERE FREETEXT(*, '%" & search & "%')"I'm using the above statement to select all records in the contactData table where the value held by the 'search' variable is part of any field. However, it doesn't work for part-words. If that's not terribly clear, here's an example.If I search for 'dan', it won't pick up 'daniel'. Are there wildcards I can use?Dan |
|
|
|
|
|
Freetext Searches