SQL Server Performance

contains

Discussion in 'SQL Server 2005 General Developer Questions' started by arkiboys, Mar 18, 2009.

  1. arkiboys Member

    Hi,
    I tried:
    select * from Table1 where contains(field1, ' "redemption of notes" ')
    This returns anything that has the word "redemption" or "Notes" in it only. It seems to ignore the word "of"
    It also returns "redemption Amount notes"

Share This Page