>I have a SQL command like this:
>
>

>SELECT ...
 IIF(ISNULL(Member.NoSchool),0,Member.NoSchool) AS NoSchool,School.SchoolT,Video.NoClass,;
...
 LEFT JOIN Member AS Member2 ON Video.NoMember2=Member2.Numero;
 WHERE Video.Active2 AND Video.DateR<={^2006/10/09 07:46:15}

How about CAST(NVL(Member.NoSchool, 0) as I) ?

regards

thomas