...Must NoLock be used only on a query selecting from a table, or can it be on a table-returning function?
You better not to use NoLock at all.
What is your reason behind using it? What are you trying to achieve?
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]