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")
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould