1 Reply Latest reply: Apr 12, 2011 11:37 PM by Oleg Troyansky RSS

    Where clause

    MCPL MCPL

      Hi,

      Am having a spot of bother with a 'simple' where clause when loading from a qvd file.

      Background: I have 2 fields SURNAME and FULLNAME. I want to exclude any value where there is a double bracket attached to the end of either field.

      Code as follows:

      Where Right(SURNAME,2)<>'))' OR Right(FULLNAME,2)<>'))';

      Have also tried:

      Where Right(SURNAME,2) OR Right(FULLNAME,2)<>'))';

      When running the command none of the defined values for exclusion are actually excluded.

      The command works fine if I run the code with only 1 field defined (without the 'OR' clause).

       

       

        • Where clause
          Oleg Troyansky

           


          Karl wrote:I want to exclude any value where there is a double bracket attached to the end of either field.


          If you want to exclude the values if either of the fields has brackets, it means (in reverse) that you want to include only those values where both fields don't have the brackets. Simply put, you need to replace your OR condition with an AND condition, and I believe it will work the way you wanted...