Search Issue

• ningaraju.n

  SSCrazy

  Points: 2322

  More actions

  October 19, 2012 at 6:54 am

  #96979

  I have a table with string column called keywords

  please find the sample data

  IDKeyWords

  1abc efg

  22hig klm nop

  3qrs tuv wxy z

  And i have input string as follows

  @IP ='I am finding difficult abc efg and please help 2hig klm nop z thanks'

  In the string 'abc efg' and '2hig klm nop' getting matched with the keywords column value.

  eventhoug in the string 'z' is there but it is not completly not matching with column value.

  So i need only two records ie

  ID Keywords

  1abc efg

  22hig klm nop

  I tried with full text queries but not able to find the solution

  Please suggest the solution with any approach

  Thanks in advance.

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  October 19, 2012 at 7:08 am

  #1550853

  Read about the SUBSTRING function or the LIKE operator. Either of those should give you what you require.

  John