This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Apr 2, 2013 12:39 PM by Frank Kulash RSS

Please Help: query matching string value in WHERE clause

992633 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points