I am using sql server 2000 and I have setup full text indexing on a few columns in this table. I am using the following sql.
FROM company c
WHERE CONTAINS(companyName, ' "S*" ')
This query works, but for some reason (I think because I am using CONTAINS) I am getting a record back that does not start with S as the first word, its actually the 3rd work in this particular companyName and its coming back and in my resultset.
I get this in the resultset: ABC IT Solutions, Inc.
I want it to only look at the first letter of the companyName. I tried using Left() but to no avail. It appears it sees the word Solutions when I do s*. The docs say this should work I believe.
Any help appreciated