1 2 Previous Next 15 Replies Latest reply: Apr 2, 2013 2:39 PM by Frank Kulash RSS

    Please Help: query matching string value in WHERE clause

    992633
      Hi Everyone,
      I am trying to query customers that has matching first and last name but, I am getting result of every customer that has first and last name. Here is what my query looks like:
      SELECT * FROM  CUSTOMERS WHERE
       CUSTOMER_FNAME IN
       (
       'JOHN', 'MIKE'
       )
      AND CUSTOMER_LNAME IN
       (
       'DOE', 'MILLER'
       ); 
      I am trying to query customer name that is JOHN DOE and MIKE MILLER but, i get result of all names that has the first/last names not exact match. Is there way i can do that get exact match?


      Thanks,
      SM
        1 2 Previous Next