Error 7631 Expected ''''' near ..

  • Thread starter Thread starter Dino M. Buljubasic
  • Start date Start date
D

Dino M. Buljubasic

I am querying data using full text indexing like:

SELECT a, b, c
FROM X
WHERE whatever
AND CONTAINS(fldField, 'john doe')

and I get error 7631. Syntax error near 'doe'. Expected ''''' in search for
'john doe'.

Can somebody help me with this please. I am querying from SQL Server.

Thank you,
 
I am querying data using full text indexing like:

SELECT a, b, c
FROM X
WHERE whatever
AND CONTAINS(fldField, 'john doe')

and I get error 7631. Syntax error near 'doe'. Expected ''''' in search for
'john doe'.

Can somebody help me with this please. I am querying from SQL Server.

Thank you,
Click to expand...
they should be double-quotes round john doe.
 
Back
Top