Database Functions

[CF_output]

Hey all, I can't say I've ever had to use a stored database function. Does
anyone know if there is some documentation or examples for using functions
instead of stored procedures - or can I use a function the same way I would use
a stored procedure?

Thanks!

[CF_output]

In MS SQL, its under a database --> Programmability --> Functions -->
Scalar-valued Functions.

I believe I found the solution, I can access the function via cfquery instead
of cfstoredproc.

Example:
SELECT test, dbo.function_test(param1,param2) as myTest
FROM TestTable
WHERE test = 1