>Is there a way of getting output from a scalar SQL Server udf via SQLEXEC.. not a cursor, but just a single value..
>Something that would correspond to the way we can get an output value from a stored procedure:
>SQLEXEC(nHandle,"Exec myproc ?@nOutput")

Ilmar,

Try to cal UDF this way

lnRetval = 0
lcSql =[{?@lnRetval=Call dbo.ufn_val('123')}]
lnResult = Sqlexec(lnConn , lcSql)
IF lnResult < 0
	* ODBC Error
ENDIF
? lnRetval