• -- either (LEN ignores trailing spaces)

    LEFT(vm.VCTCollectZipcodeId, LEN(vhml.ZipcodeFrom)) = vhml.ZipcodeFrom

    -- or

    vm.VCTCollectZipcodeId LIKE vhml.ZipcodeFrom + '%'