Hi Everybody!
I have an application that was devloped using VFP 6.0 SP4 and Microsoft SQL Server 7, we moved to VFP 7 SP1 and Microsoft SQL Server 2000 and after that
we can not query on NULLS or empty spaces, something like this :

SELECT * FROM MyTableName WHERE MyFieldName = NULL

OR

SELECT * FROM MyTableName WHERE MyFieldName = ''

I tried these command from both SQL Analyzer or using SQL pass through from VFP and in both cases returned not records. Also, I tried setting the SET ANSI_NULLS ON/OFF without any results.

Any suggestions ?

THIS.Thanks("in advance")