Search: CONTAINSTABLE

[jeffejohnson]

I'm trying to write a query to associate to an alternate key. Can
someone provide the right syntax/keyword I need to accomplish this?

Here's the line that keeps giving me the error (Operand type clash:
uniqueidentifier is incompatible with int):

JOIN CONTAINSTABLE(VocabularyFrench, *, 'FORMSOF(INFLECTIONAL,
"remorques")') SRCH ON P.PRODUCT_ID = SRCH.[KEY]

Thanks,

Jeff

[M A Srinivas]

On Jun 19, 2:32 am, [e-mail] wrote:

I'm trying to write a query to associate to an alternate key. Can
someone provide the right syntax/keyword I need to accomplish this?

Here's the line that keeps giving me the error (Operand type clash:
uniqueidentifier is incompatible with int):

JOIN CONTAINSTABLE(VocabularyFrench, *, 'FORMSOF(INFLECTIONAL,
"remorques")') SRCH ON P.PRODUCT_ID = SRCH.[KEY]

Thanks,

Jeff

Instead of * (all columns ) , provide columns list which are of data
type character ( char,varchar,nvarchar)