views:

83

answers:

1

I have a user defined function defined in SQL Server. I want create a single select statement that would be able to execute the function on all rows in a particular column. Is this possible and what would be the best way to do it?

Thank You

I saw this 'Execute table-valued function on multiple rows' and dont believe it answers my question.

http://stackoverflow.com/questions/454945/execute-table-valued-function-on-multiple-rows

+2  A: 
select dbo.YourFunc(column) as result
from table

PS: Stop thinking procedurally! It's a set-oriented language :)

GSerg