http://msdn.microsoft.com/en-us/library/aa175085%28SQL.80%29.aspxUser-Defined Functions --Calling User-Defined Functions ----However, when you call SQL Server built-in functions that return a table, you must add the prefix :: to the name of the function:
--Calling User-Defined Functions
----However, when you call SQL Server built-in functions that return a table, you must add the prefix :: to the name of the function: