sql server full text search: Got a bizarre problem

In our search box, someone types in the search term:
A$

This results in the PARTIAL SQL:
......AND (CONTAINS(TableToQuery, ' ""A$"" '))

And this results in the error:
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.

The set of "noise" words:
C:\Program Files\Microsoft SQL
Server\MSSQL\FTDATA\SQLServer\Config\noise.eng

has two lines that appear relevant:
$
a b c d e f g h i j k l m n o p q r s t u v w x y z

But the "word" being searched is "A$" and not "A" with "$".

Can someone explain why I'm getting this particular error?

Thanks in advance

Griff

PS - Using SQLServer 2000 on Windows 2003 being queried from an ASP script
running in IIS under Windows 2000. I know that the "word delimiters" list
is different on Windows2000 & Windows 2003, but I don't know if there are
any other server- related issues.

You need to remove the a, so the lines would look like
$
bcdef.....

The $ is thrown away so a search on a, a$, or $a would give hits to a, a$,
$a, !a, a!, etc.

After you make your change to the noise word list - for US english noise.enu
found in

C:\Program Files\Microsoft SQL Server\MSSQL$SQL2000\FTDATA\SQLServer\Config
stop mssearch, save your changes, restart mssearch and do a full population.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

Hi Hilary

Many thanks for your response. I have a few further questions just to help
clarify my understanding.

You say that the $ symbol is "thrown away". What are the exact criteria for
throwing these characters away? I.e., are they ALWAYS ditched, only ditched
if on the end of a word...etc?

Presumably the $ character is ditched when the data in the table field is
actually indexed. As an example, say that I had the following text in the
table "abcd$efgh". How would this be saved in the full text index: as a
single word "abcdefgh" or as two words "abcd" and "efgh"? If I wanted to
enter a search term that would return this row, I'd presumably have to enter
the indexed word (so either "abcdefgh" if one word or either "abcd" or
"efgh" if two words); entering "abcd$efgh" presumably would return no hits.

If $ is a "throw away" character, what other characters are also thrown
away? The reason I'm interested in this is that I want to pre-parse the
search terms that are entered to see if they are suitable for use within a
full-text query. So, I'd need to throw away all $ characters (and all the
other characters that are also known to be thrown away when the full text
index is searched) and see what was left. Is this simply the list in the
noise.eng file (UK English)? Are the criteria for throwing these characters
away the same for all characters? I assume that they must be.

Many thanks

Griff