I want use a UDF to create a new variable in a SQL select statement to crate a cursor for a
report. The UDF would also be used to update a table using SCAN/ENDSCAN latter on.
Calculation depends on 4 fields. I tried something like

SELECT a,b,c,d,e,f,udf() as name from table

to test it. Only one value is return (one calculated for first record). Do I have to pass
all the fields to the UDF and use local variables? Did look at documentation, It is not
clear on how to do this.

TIA.