>I've run the select from within SSMS
>"SELECT SUM(CALLCOUNT) AS CALLS FROM BI.dbo.BI01 WHERE " +
>"WEEKNO = ? AND SUBSTRING(LOC, 1, 2) = ?";
>
>and if no records are selected , one record is returned with NULL in CALLS field... so this expalins the eror message
>
>When I issue the same SQL select in VFP, no records are returned, which I was assuming would have been the same in SQL Server
>
>Regards,
>gerard
>
>
You're running an older version of VFP. In the latest VFP version (version 9) it also returns one record with NULL.