full text search - embedded dots
-
Hi all
I have names such as "H.B.F", and other combos without the dots, namely "HBF", i cant get the fulltext engine to return me the HBF records if I type in H.B.F for example, any thoughts on this?? i thoughts this sort of thing was built into mssearch.
In the example mentioned, it returns words that start with H, B and F in a series, not that helpful 🙂
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA" -
It would work the other way around. Depends on whether it's going to break your app if you remove the dots prior to issuing the search. Eg.
SELECT MyText
FROM MyTable
WHERE CONTAINS(MyText, ' "HBF" ')
MyText
The Company id is H.B.F.
The Company id is HBF.
The Company id is H.B.F, but the fullname is longer
The Company id is HBF
The Company id is H.B.FCheers,
- Mark
Edited by - mccork on 09/11/2003 10:29:14 PM
Cheers,
- Mark -
Hi there
Im not sure about this.. here is my test:
Org ID Org Name
1077818 H.B.F HEALTH FUNDS INC
SELECT orgname_name
FROM organisation_name
where CONTAINS(*, '"HBF"')
gives me this:
orgname_id Org Name
1077819 HBF HEALTH FUNDS INC
1080948 HBF Health Funds Inc
1081009 HBF Health Funds Inc
and of course:
SELECT orgname_id, orgname_name
FROM organisation_name
where CONTAINS(*, '"H.B.F"')
gives me:
Server: Msg 7619, Level 16, State 1, Line 1
Execution of a full-text operation failed. A clause of the query contained only ignored words.
I do have a neutral language breaker, ill check this next...
Strange!
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA" -
whoa
my apoligies Mark!
The table supports multiple names for an org, i was using the wrong identifier to uniquely locate a "group" of names for an org, I altered the code slightly and the search over HBF will bring back H.B.F records.
It must be Friday 🙂
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA" -
Not only that, it's after lunch Friday.
Cheers,
- Mark
Cheers,
- Mark -
i dont know what your talking about
hic!
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply