>I created a temporary cursor for searching using "SELECT * FROM table WHERE expression INTO CURSOR temp" and would like to know how to destroy that cursor on exit and null it out between searches.
>
>Would someone help?
>

USE IN TEMP eould close the cursor created with the alias TEMP (as in your select, statement) and it would immediately go away.

>Thanks in advance.
>
>Jason Nance
>
>Illinois State University - Office Of Residential Life
>Residential Computing - Programming Services