0 Replies Latest reply on Dec 15, 2014 5:51 PM by 2814629

    Writing a condition based off a list of numbers

    2814629

      Hi all,

       

      I have a set of 100 or so account numbers that are 16 digits long. My current method is doing this:

       

      where account_number in ({copy and paste comma delimited numbers})

       

      Is there some way that I can implement some sort of list? This makes the query really long, and since I'm usually copying these from excel, I have to insert the commas manually. I've tried to export the excel file into a comma delimited csv file, but it hasn't been working like I want it to. Even if this did work, I would still have to manually clean up the query so it looked nice and legible.

       

      Any help would be appreciated!