Comparing any value to NULL will return False. Please will you show us your query?

John

Edit - I think I see what you're trying to do. Will this work?

WHERE COALESCE(TyreID, @TyreID) = @TyreID

AND COALESCE(CarID, @CarID) = @CarID

AND ...