>Is there a way to use one function in a select statement to return values for two distinct columns in the cursor?
No. One function per column:
SELECT ;
Func1(ParameterList1) AS Column1, ;
Func2(ParameterList2) AS Column2, ;
...
Why do you want to get two columns back from one function?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up