CONTAINS statement

• joann coffey

  Newbie

  Points: 3

  More actions

  December 15, 2004 at 9:47 am

  #60033

  I am trying to build a search form so a user can input their search term.  How do I handle the contains statement?  do I 1) - add a contains statements for each word or 2 ) - just add all words into the one contains statement?

  1 - CONTAINS (p.*, '"lighting"') AND CONTAINS (p.*, '"futures"')

  2 - CONTAINS (contents, '"lighting and futures"')  

   

• Razvan Socol

  SSCarpal Tunnel

  Points: 4811

  More actions

  December 15, 2004 at 9:59 am

  #533986

  AFAIK, the correct syntax is:

  CONTAINS (contents, '"lighting" AND "futures"')

  Razvan