How do you call a stored procedure, in SQL, when you need one of the parameters to be one of the built in SQL scalar functions? What I know doesn't work is this:
exec MyStoredProc 'Param1', ScalarFunction(value)
exec MyStoredProc 'Param1', dbo.ScalarFunction(value)
and neither of those work with tick marks around the call of the scalar function either.