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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]