>For example, the following code works:
>select * from tblgl order by tblgl.tempgl into cursor test
>The code below does not work:
>ctemp = "tblgl.tempgl"
>select * from tblgl order by (ctemp) into cursor test
>Is there a way to use a memory variable in a SQL Select statement?

Try :

select * from tblgl order by &ctemp into cursor test

that should work for you.