5 Replies Latest reply: Jun 20, 2014 6:11 AM by Anand Chouhan RSS

    Ranges in script

      Good day,

       

      I have the following script:

       

      LOAD

       

      AccountCode               as  Account,
      CustomerSName          as Customer,
      NLControlAccount         as [NL Code],
      CompanyKey

      SQL

      SELECT
      AccountCode,
      CustomerSName,
      NLControlAccount,
      CompanyKey

       

      I only want to pull info where the NL Control Account is bigger than '20000000000' and smaller that '400000000000'.

       

      This I want all the NL Control Accounts that is between 300000000000 and 39999999999.

       

      Not sure how to write it in the script.

       

      Please advice.

       

      Thank you

      *R*