• Can you try changing the order in your WHERE clause to 'WHERE (@num1 = 0 or colOne = @num1)'?