>How about CAST(NVL(Member.NoSchool, 0) as I) ?
Yes, that would work also.
BTW, I do now understand why the SQL is different in the NoSchool field, when it produces the * character as the value, when using the WHERE clause. I didn't remember that this is based on the first record it finds in the SQL and that would be different when the WHERE clause is present.