>>>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 ?

of course.