Don't know about specific error, but I can tell you the use of "trim" in an index is extremely bad form.

Reason, the two names below would be equal as far as your index is concerned:

ROD SMITH
RODS MITH

Trimming and concatinating these 2 names yields exactly the same result, but they are clearly not the same name.

>Hi
>just wondering whats wrong with syntax below !!?
>
>index on trim(upper(surname))+trim(upper(firstnames)) tag NAMEUNIQUE FOR internal=1 CANDIDATE
>
>the error is ,Command contains unrecognized phrase/keyword (Error 36)
>
>if i remove keyword "candidate" it goes thru fine but i need to create unique index.
>any ideas much appreciated