assign "all values" instead of "null" in Conditional Where clause
You can do something like this :

SELECT *
FROM vehicle_register
WHERE (vehicle_type = @param OR @param is null)


You are using parameterized queries and not just a query build by string concatination in the frontend I hope.