>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" && pull only 01-10 >Hi Tracy
SELECT * FROM myfile WHERE ALLTRIM(cvalue) == "01-10" && pull only 01-10but with between function where to write "==" ;o)