Hi!

I would like to write a user-defined function that performs a lookup
operation on a db table as part of its calculations. I was wondering,
what would be the best way to achieve this?
I know that such a functionality could be achieved by writing a stored
procedure. But it is not possible to use stored procedures that return
scalars in the same manner as functions, right?

Thank you,
Christof