0 Replies Latest reply on Sep 29, 2006 9:55 PM by Newsgroup_User

    Re: MS-SQL - Like search form from a group of products.

    Level 7
      LIKE is for searching strings (varchar, char, text) only.

      Also, you're allowing null prices on product IDs other than 51. Your
      conditions will be read as
      WHERE (P.Price IS NOT NULL AND PC.cid=51)
      OR PC.cid=52
      OR ...

      You should instead use
      WHERE P.Price IS NOT NULL AND PC.cid BETWEEN 51 AND 54