Where you say "incomplete" results, are you talking about a value being trimmed or converted? The RESULTS SETS forces a specific mask for returned data. If you had your years in a format longer than 4 characters (unlikely) for example, it would potentially trim it to 4. If you had a discrepancy in your nulls, you'd get an error back and no results set.