Hello:
I am using a SQL statement using ContainsTable. Below is an example of the SQL code that I'm using.
The results come back with everything with Steele and mail. (leaving out the e-)
Issue: I know the - in 'e-mail' (so it appears "e mail") is being deleted in the full text search cause it is (at least I think) a noise word (or symbol) yet when I check the noise word file the - is not in the list. (Which means it should be included in the serch, right?)
What I want to do is to figure out a way to search for "e-mail", if it's possible.
Thanks in advance for your help.
P.S. - One additional question. Where can I find a list of noise symbols. Thanks.
I am using a SQL statement using ContainsTable. Below is an example of the SQL code that I'm using.
Code:
Select x.F1,x.F2,c.Rank
From TableX x
JOIN ContainsTable c (Z,Text, "Steel" AND "e- mail") AS c ON c.Key = x.F1
Order By c.Rank
Issue: I know the - in 'e-mail' (so it appears "e mail") is being deleted in the full text search cause it is (at least I think) a noise word (or symbol) yet when I check the noise word file the - is not in the list. (Which means it should be included in the serch, right?)
What I want to do is to figure out a way to search for "e-mail", if it's possible.
Thanks in advance for your help.
P.S. - One additional question. Where can I find a list of noise symbols. Thanks.