>Is there a way to use one function in a select statement to return values for two distinct columns in the cursor?

My guess is that you're after something like FirstName and LastName from an ID. Perhaps you could send a parameter to your function like

SELECT GetName(ID, "First") AS FirstName, GetName(ID, "Last") AS LastName ...

*!* Dumb code here, but you get the idea
FUNCTION GetName(lnID, lcWhichName)

    LOCAL lcRetVal

    SEEK(ID, "SomeTable", "ID")

    IF lcWhichName = "First"
        lcRetVal = SomeTable.FirstName
    ELSE 
        lcRetVal = SomeTable.LastName
    ENDIF

RETURN lcRetVal