Search phrase full text

Question

I use the following SQL: select specification from tblProduct where contains(specification, ' "<td>Interfacetype</td><td>: </td><td>Hi-Speed USB" ');

This gives no result. Why does this not work???

Answer 1

does this work?

select specification from tblProduct where contains(specification, ' "Interfacetype Hi-Speed USB" ');

---

looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941