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!

[Dan_Bracuk]

The term database function is ambiguous.

[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