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 |
|
hark1204
Starting Member
2 Posts |
 Posted - 2001-08-08 : 10:09:15
|
| Hello All,I have full-text indexing enabled for a table in my database.We have a ASP page as part of our application that queries the database for part numbers and descriptions usingthe CONTAINS predicate.Queries work well except when we query for part numbers that begin with numbers. If I query for part number '12H 2-1/4' by inputing '12' or '12H' into an input box I get No Results. If I input '12H 2'.I get the part numbers. I get the appropriate results with a like query.If I query for part number 'MB 4-17/16' by inputing 'MB' I get the expected results.Full part number queries work well.Here is the where clause:WHERE CONTAINS(part_no,' " & chr(34) & strPrtNo & chr(34) & " OR " & chr(34) & strPrtNo & "*" & chr(34) & " ')I allow all words to be indexed by having a minimal noise list.Thanks in advance for any help,DaveDave |
|
|
|
|
|
CONTAINS query results problem