>Hi,
>
>on my cursor i need uses one field C(250) and INDEX it.
>
>I cannot directly.
>
>I can indirectly ? Like ?
>
>
>Fabio
You can index on left(fieldname,240), but you will have to use the same expression on select and seek to be optimizable.
Or if you can, shorten the field len to 240 chars (239 if nullable).
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca