Full Text Search Question.

Does anyone know if full text search has a problem with numbers?

I have a text field in a table that has been full text indexed. Some of the data in some of the fields start with numbers.
For Example
"123p45 the bla bla bla"
When I run a standard SELECT statement on LIKE '%p4%' it returns the record.
If I run a full text query using CONTAINS(fieldname,'"*p4*"') it returns nothing.
After much head banging I was able to get the CONTAINS to work when I used *123p4*
I figured since there are alpha characters after the p4 the * works however since there are no preceeding alpha characters before the p4 it fails.
I would like to be able to do a "full text" search for the "p4" and get the record above.

Any feedback would be appreciated..

Hello,

You can take a look here

http://www.databasejournal.com/features/mssql/article.php/3441981

http://www.databasejournal.com/features/mssql/article.php/1438211

http://www.sql-server-performance.com/full_text_search.asp

|||

These articles explain how to set up a full text index. I already have it set up.
I just want to know if there is any reason why when I search for the p4 listed above
using a CONTAINS select it returns nothing.