possible to call a table valued User Defined Function thru ODBC

I want to be able to call a SQL Server User Defined Function that is a
table valued UDF. I have existing code that uses ODBC and calling UDFs
is going to be a lot easier than calling stored procedures, as the
syntax is close to using a table itself (at least in T-SQL it is).
But, I suspect that only scalar-valued functions can be called, but
please tell me otherwise.I don't believe you can return a TABLE variable from a UDF
directly through to ODBC.
How is calling a UDF simpler than calling a stored procedure?
By the way, if you want the database layer written for you in
ADO.NET (if you are using .NET...), you can use this code
generator (source code included).
http://www.eggheadcafe.com/articles...e_generator.asp
2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net
http://www.mastervb.net
"fpdave" <deroberts100@.hotmail.com> wrote in message
news:1106230769.823842.53790@.z14g2000cwz.googlegroups.com...
>I want to be able to call a SQL Server User Defined Function that is a
> table valued UDF. I have existing code that uses ODBC and calling UDFs
> is going to be a lot easier than calling stored procedures, as the
> syntax is close to using a table itself (at least in T-SQL it is).
> But, I suspect that only scalar-valued functions can be called, but
> please tell me otherwise.
>