I have a SQL command like this:

SELECT Video.Numero,Video.Active2,Video.DateR,Video.Notes_E,Video.Notes_F,Video.Running,Video.VideoT,Video.NoVideoT,Masters.FirstName,;
 Masters.LastName,Video.NoVideoL,Video.NoMaster,Video.NoMaster2,Video.NoMaster3,Video.NoMember,;
 VideoType.Title_E AS VideoType,VideoLanguage.Title_E AS VideoLanguage,Programs.ProgramT,Video.NoProgram,;
 IIF(ISNULL(Member.NoSchool),0,Member.NoSchool) AS NoSchool,School.SchoolT,Video.NoClass,;
 VideoClassification.Title_E AS Classification,Video.Url,School.Url AS SchoolUrl,VideoSize.VideoSizeT,;
 Video.NoMember2,Member2.FirstName,Member2.LastName;
 FROM Video;
 INNER JOIN Masters ON Video.NoMaster=Masters.Numero;
 INNER JOIN VideoType ON Video.NoVideoT=VideoType.Numero;
 INNER JOIN VideoLanguage ON Video.NoVideoL=VideoLanguage.Numero;
 LEFT JOIN Programs ON Video.NoProgram=Programs.Numero;
 LEFT JOIN Member ON Video.NoMember=Member.Numero;
 LEFT JOIN School ON Member.NoSchool=School.Numero;
 INNER JOIN VideoClassification ON Video.NoClass=VideoClassification.Numero;
 INNER JOIN VideoSize ON Video.NoVideoSiz=VideoSize.Numero;
 LEFT JOIN Member AS Member2 ON Video.NoMember2=Member2.Numero;
 WHERE Video.Active2 AND Video.DateR<={^2006/10/09 07:46:15}

As is, the result in the NoSchool field would be having a size of one for the NoSchool field. Thus, I end up with some * in some records because I have values higher than 9 in some records.

However, if I remove the second part of the where clause, which is the Video.DateR filter, the NoSchool field would then be ok.

Can someone explain me that where behavior?