Thank you for your response.
The problem I have is that when I evaluate the SQL Statement in VFP, before I send a SQLEXEC, the statement may look like this :
Select * from table1 where .T. and .T. and Table1.Field1 = '191'
or
Select * from table1 where True and True and Table1.Field1 = '191'
or
Sselect * from table1 where 1 and 1 and Table1.Field1 = ' 191'
.T. and True and 1 are not valid TRUE expression in Sql Server.
I am looking at a valid TRUE expression in SQL Server.
Waiting for comments...
>SQL Server has a CASE - END structure which corresponds to FoxPro IIF().
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only