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

On Jun 19, 2:32 am, jeffejohn... (AT) hotmail (DOT) com wrote:
Instead of * (all columns ) , provide columns list which are of data
type character ( char,varchar,nvarchar)