2 Replies Latest reply: Mar 14, 2013 2:57 PM by 994732 RSS

    How to pass a variable to near operator

    994732
      Hi! does anybody know how can I pass a variable to near operator?

      with this query variable1 and variable2 are read like words, not like variables.

      SELECT *
      FROM t1
      WHERE CONTAINS
      (test, 'near((variable1, variable2), 1)') > 0;

      Thank you!

      Best regards
      Sara