>>Try this:
>>
>>CREATE cursor TEMP (Fld1 I)
>>
>>INSERT INTO TEMP VALUES (100)
>>INSERT INTO TEMP VALUES (110)
>>INSERT INTO TEMP VALUES (113)
>>INSERT INTO TEMP VALUES (115)
>>INSERT INTO TEMP VALUES (119)
>>
>>INDEX ON Fld1 TAG Temp
>>
>>SEEK [100 Test TestMe]
>>? FOUND()
>>
>>INDEX ON STR(Fld1) TAG Temp
>>SEEK 100
>>? FOUND()
>>
>>
>>Maybe this is disused somewhere but I have missed that discussion.
>>
>>I always use ORDER in seek, but in ONE place I didn't and viola!!!!! what I found.
>>When the order is based on Numeric (some kind) field you could seek strings and VFP didn't complain and above that IT FOUND() the string :-)))) (if the string begins with numbers)
>>
>>But if the order is STRING based you can't search anything but strings in it.
>>Grrr!
>>
>>SO: ALWAYS USE "ORDER" clause in SEEK :-)
>
>I confirm this happens with VFP9 SP1, and with VFP5 SP3. If it's been around that long, it's definitely a "feature, not a bug" :)
>
>BTW when I first looked at your message I saw "viola" and "strings" so I thought you were talking about music ;) I think you mean, "voila".
I wrote "Viola"? [ROTFL]
Sure I meant "VOILA", fat fingers :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.