full-text index query question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I'm trying to construct a query to a full-text index from an Access 2007
form to SQL Servert 2005.

my query is

SQLStr = "SELECT EventId " & _
"into tbltempsupersearch " & _
"FROM dbo_tbleventsdocs " & _
"WHERE CONTAINS(content,'""blah""')"

I get an error message undefined function 'contains' in expression.....
I've removed content and replaced with *, I've removed it altogther and tried
a variety of "" and '

thanks much
 
Jen said:
I'm trying to construct a query to a full-text index from an Access 2007
form to SQL Servert 2005.

my query is

SQLStr = "SELECT EventId " & _
"into tbltempsupersearch " & _
"FROM dbo_tbleventsdocs " & _
"WHERE CONTAINS(content,'""blah""')"

I get an error message undefined function 'contains' in expression.....
I've removed content and replaced with *, I've removed it altogther and tried
a variety of "" and '
Click to expand...


I don't use SQL Server, but Access doesn't use Contains.
Try something more like:

"WHERE content LIKE '""%blah%""')"
or maybe:
"WHERE content LIKE '""*blah*""')"
 
Back
Top