>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

The reason for this error is that the index expression does not always create index keys of fixed length, which is a requirement.

index on padr(upper(trim(surname)+trim(firstnames)),50) tag NAMEUNIQUE  FOR  internal=1 CANDIDATE

Or even shorter

index on padr(upper(surname-firstnames),50) tag NAMEUNIQUE  FOR  internal=1 CANDIDATE