My coding purpose is something as following:

strqry = sqlexec(myconnection,"select name, age, remarks from temployee where age>=20","c_emp")

if ISNULL(c_emp.remarks) or EMPTY(c_emp.remarks)
thisform.myfunctionA()
else
thisform.myfunctionB()
endif

The problem is even though the field is actually NULL value, the condition's still wrong.
I wonder how the SQL Server return the NULL values? Because, If I use nvl function in such cases : "lcremark = nvl(c_emp.remarks,"")", then it's worked.
Thanks a lot for u all suggestions.

Regards,
Mya