0 Replies Latest reply on Sep 29, 2006 3:54 PM by Newsgroup_User

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

    Level 7
      tHANKS
      "Lionstone" <HIDElionstone@HIDEhushmail.com> wrote in message
      news:efjtfp$k6p$1@forums.macromedia.com...
      > 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
      >
      >