Hi ng,

found out about index key size the hard way yesterday, so now I'm
trying to reduce field sizes to the minimum.
isn't there a way to reduce the size of a varchar field by SQL?
I tried this here ("Vorname" is of size 60 now):

>>ALTER TABLE "Divers1" ALTER "Vorname" TYPE VARCHAR(40)<<

but got an error ("must be at least 60").

Thanks for your help,

Thomas Besand
Berlin, Germany