Ask a questionAsk a question
 

AnswerSearch phrase full text

  • Tuesday, October 13, 2009 7:13 PMHenk99999999 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    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???

Answers

  • Wednesday, October 14, 2009 12:38 PMHilary CotterMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    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

All Replies

  • Wednesday, October 14, 2009 12:38 PMHilary CotterMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    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