I want to pass a value into a variable and convert it to a reserve word.
I want to make the sorting dynamic like ASC or DESC. Any Suggestion?

FUNCTION TEST
LPARAMETER lpSORT

SELECT * FROM DATABASE1!TABLE1 WHERE ;
ORDER BY column1 lpSORT

ENDFUNC