SQL Server – Skipping Function Execution when parameters are NULL

(Vishal Gajjar) You can avoid executing a function when NULL values are passed as parameters. To achieve this you need to create function with RETURNS NULL ON NULL INPUT, this option introduced in SQL Server 2005.

Read More - Register for Free Membership