>I send the SPT to SQL Server and receive the recordset with a VFP Cursor. In the processing with that cursor, when I want to filter a field whether it's empty or null by using these functions like EMPTY() or ISNULL(), I can't get a correct answer eventhough the field is having NULL value. For Example:
>
>IF ISNULL(temployee.remarks) or EMPTY(temployee.remarks)
> this.value=""
>ELSE
> this.value=temployee.remarks
>ENDIF
>
>The condition is always false eventhough the value is having NULL.
>What else function should i use or am i wrong filtering?
>Appreciating all your suggestions.
>Thanks.
>
>Mya
I donæt use SQL server myself, but my guess is that your cursor simply has NULL as text. Check for temployee.remarks#'NULL'.