This is actually very easy to do without using Dynamic SQL - never the nicest option. All you need to use is the isnull function in your stored procedure

The isnull...