>>>>
>>>>

>>>>select * from myTable where 1=0
>>>>

>>>>
>>>>Will that work?
>>>
>>>You can also do:
>>>
>>>

>>>Select * From myTable Where .F.
>>>

>>>
>>>Renoir
>>
>>Or,
>>
>>select * from mytable where "YES"="NO"
>>
>>This would be the slowest version. *grin*
>
>LOL!
>
>Hmmmm... How about:
>
>

>select * from mytable where Alltrim(Str(Val(IIF("YES",1,0)))) = Alltrim(Str(Val(IIF("NO",0,1))))
>

>
>Renoir

Ooops! Syntax error...

select * from mytable where Alltrim(Str(Val(IIF(<B>"YES" = </B>"YES",1,0)))) = Alltrim(Str(Val(IIF(<B>"NO" = </B>"NO",0,1))))

Like it matters... <g>