Yes, it is, and I even wanted to write that. But I thought that I should try it first. Since I received an error message, I thought it was a syntax error, but it was a "Uniqueness of index xx is violated" message. I'm off to the optometrist now to get new glasses! :-)

In other words the shortest syntax is

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

>Hi Tore,
>

>surname-firstnames
>

>
>should not need PADR. The spaces from surname are moved to the end of the string.
>
>Agnes
>>>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