At 06:18 PM 11/21/2004, =?ISO-8859-2?Q?Michal_=AEerav=EDk?= wrote:

>is it possible to declare explicitly size of the index on [var]char column?
>When I have ie. varchar(255), can I specify index for sorting only from
>i.e. first 5 letters?
>Something like create index xx on tablee(myvarchar(5));

No, but you can create a second field that is populated and
maintained with triggers using the substring function and
use that field for the index.

Regards,


Ann