>>>function ReturnInfoByStateCategory
>>>...
>>>return info as a cursor.
>>>
>>>Should I use UDF or SP with Cursor Output? Which way is preferable?
>>
>>Only UDF can return table.
>
>I may need cursor only, not the table. What is better in general?
>
Are you sure? You cannot use SQL Server cursor in set oriented commands, like SELECT.