>Hello
>
>Yes the problem is because always in VFP : ('' = 'a') or ('' = 'x') ...
Not always but never. ('' = 'a') and ('' = 'x') always return .F.
>
>You must add : AND !EMPTY(xx)
>
>Goodbye
>
>Lionel
On other hand. the result of ('a' = '') or ('x' = '') depends on setting of SET ANSI for the SQL select and SET EXACT for the rest of commands.
--sb--