4 Replies Latest reply: Jun 14, 2013 3:40 AM by Alessandro Saccone RSS

    script Query

    Sukhwant Matharoo

      hi all,

       

      i have a qvd and in script i need to write  a where clause on 1 column with multiple selections. what is the shortest way to write:

       

      load * from test.qvd(qvd)

       

      where

       

      country in ('AU','GB','US','CA')

      and currency not in ('USD','EUR','GBP')

       

      please advise the right syntax for the above where clauses

       

      thanks in advance