Forum Stats

  • 3,759,170 Users
  • 2,251,509 Discussions
  • 7,870,522 Comments

Discussions

CONTAINS operator issue

User_6IW5U
User_6IW5U Member Posts: 1 Green Ribbon

Hey guys, so I'm stumped here.

Say I have 2 records in table "t" where the SEARCH_NAME column is indexed by CONTEXT:

SEARCH_NAME

-----------------

REED, JAMES D

REED, JAMES J


I want to search for the first record using the CONTAINS operator. I would've expected this to work, but it does not as it will return both records. Any one have any idea how to get only the first?

SELECT * FROM contacts WHERE CONTAINS(search_name, 'REED\, JAMES D') > 0;