Hi Ulises,
How big are your fields? The maximum key length is 240.
>Hi all...
>I have a table which sometimes I need it to be sorted using two fields. In the table design I set a regular index like:
>Name: MyIndx, type Regular, expression field1+field2
>
>The command SET ORDER TO fieldx works fine but if I issue the command "SET ORDER TO myIndx" it sorts only by one of the fields.
>What am I missing?
>
>Thanks in advance
>
>Ulises
kenweber
GCom2 Solutions
Microsoft Certified Professional