Posted by Nate on 01/18/07 15:04

I am using the following query to search all columns in the 'dashboard'
table for the value 'Meets':

SELECT * from dashboard AS FT_TBL INNER JOIN CONTAINSTABLE(dashboard,*,
'meets') AS KEY_TBL ON FT_TBL.employee = KEY_TBL.[KEY]

I have multiple records that contain the word 'Meets', but none are
showing up as a result of this query. Any ideas?

Also, anytime I use a space in my search condition (Meets Expectations
instead of Meets) I am getting an error:
Syntax error occurred near 'Expectations'. Expected ''''' in search
condition 'Meets Expectations'.

Any ideas?

Thanks in advance.

• Next in forum: Re: Issue with CONTAINSTABLE statement
• Prev in forum: Re: Beginner question: find or create function
• Thread view: Issue with CONTAINSTABLE statement

[Reply to this message]