>>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.

I had assumed you knew and had only looked at the SQL too often - so I only left the relevant parts in. Sometimes I am too lazy/cryptic, I know...

regards

thomas