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

GAH.. Had not run a start_full for the index. All is working now.
Thanks!

Nate wrote:
> 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: Job to be run ever first for the previous calendar month
• Prev in forum: Issue with CONTAINSTABLE statement
• Thread view: Re: Issue with CONTAINSTABLE statement

[Reply to this message]