>This works for me. Not sure if it will in VFP6 though:
>
>CREATE CURSOR myfile (cvalue C(20))
>FOR i = 1 TO 100
> INSERT INTO myfile VALUES ('01-'+TRANSFORM(i))
> IF i = 10
> FOR i2 = 1 TO 10
> INSERT INTO myfile VALUES ('01-10'+ALLTRIM(STR(i2)))
> ENDFOR
> ENDIF
>ENDFOR
>SELECT * FROM myfile WHERE ALLTRIM(cvalue) == "01-10"
>SELECT * FROM Myfile
>How to use exact comparison with BETWEEN?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
