>>I have a SQL Scalar-Valued function I'd like to call via SQL Pass Through and return the results. Is the possible? If so should I be using SQLEXEC( )?
>>
>Yes you sould
>
>
>lnResult = SQLEXEC(lnCon, "SELECT dbo.MyFunction(< some parameters if any >, "crsResult"
>
How will you pass parameter here? With the ?
If it's not broken, fix it until it is.
My Blog 
