16 Replies Latest reply: Nov 6, 2014 12:11 PM by Jeremiah Kurpat RSS

    Put a variable in the WHERE clause

      Hi, I have a problem with the WHERE clause.

      I'd like to filter my data not just with a field name but with a variable.

      In particluar i have done a viariable vtest='XX'&($(vyear)+'1'), (where vyear=2015 so vtest=XX2015)

      and i want to put this variable in the WHERE like: WHERE(O=$(vtest));

       

      I've done something like that with a variable made just with numbers and it works fine, but I can't make this work maybe because the variable is a string.

      Any tips?

      Thanks in advance!