full-text index query question

[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

 

[Marshall Barton]

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 '

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*""')"