>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().
The problem I think is your select statement - 1 IS a valid true expression.
What are you trying to accomplish in this statement? 'Select * from table1 where 1' is not a valid SQL statement. 'Select * from table1 where Table1.Field1 = ' 191'' is.
-Justin