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