SQL Server FAQs - Transact-SQL Understanding User_Defined_Functions http://dba.fyicenter.com/faq/sql_server_2/Transact-SQL_Understanding_User_Defined_Functions.html A collection of 17 FAQs on SQL Server Transact-SQL user defined functions. Clear answers are provided with tutorial exercises on creating and dropping user defined functions; defining and passing parameters into functions; providing and using parameter default values; defining and using table-valued functions. Please visit this Website.: http://dba.fyicenter.com/faq/sql_server_2/Transact-SQL_Understanding_User_Defined_Functions.html TThank you, Team DBAFYI - DBA Resource Center http://dba.fyicenter.com