Is there any way to return an error from a user defined function? Say that i
CREATE FUNCTION doNothing(param1 char(1) )
IF param1 = 'A'
/* do something */
ELSE IF param1 = 'B'
/*do something else */
/* Error, invalid param, do not run the function */
I hope you get the idea. They used an invalid value for a param, and the
function should not execute.
Oh, and by the way... there is a nice typo for RAISERROR if you try to use
it in a function.
"Server: Msg 443, ...