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.
[Back to original message]
|