i have used cross apply to overcome the issue. thx
"nkg" <xyz@yahoo.com> wrote in message
news:Owz%23jE8bHHA.4716@TK2MSFTNGP02.phx.gbl...
> Is it possible to pass a table's column name as a parameter to a UDF which
> returns a table?
> I just need a rough syntax something like
> select * from dbo.split(select [name] from employee,' ')
>
>
>