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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL CONTAINS clause parameter substitution problem 3
Broadband speeds not as expected 15
Create Procedure gives SQL syntax errors whatever I do 5
Inconsistent dat paremeter in query 7
sqlParameter and NULL 3
DDE command with sqlComman object 2
Run SQL comand with String from SQL Script 3
Calling Parameterized Query Using SQL Syntax 3

Back
Top