>>VFP determines the size of the fields in the resultset based on the first record in a table. Try
...
>>IIF(ISNULL(Member.NoSchool),CAST(0 AS int),Member.NoSchool)
>>...
>>
>
>Yes, I just realized that as few minutes ago.
>
>But, I am wondering which approach is now better and also in consideration of a potential migration to SQL Server as far as being compliant as most as possible. Is the ISNULL() better than then CAST(NVL(Member.NoSchool, 0) as I)?
NVL() is shorter but neither one will work for SQL Server because it doesn't have IIF() and VFP NVL() is ISNULL() on SQL Server.
--sb--