2 Replies Latest reply on May 6, 2016 6:01 AM by Stu412

    ExecuteSQL using Like or %

    Stu412

      Hi all

       

      I'm running the following ExecuteSQL command and need it to be more expansive in the data it captures.  I always have a mental block though with SQL and Filemaker so hoping to get some help.  For context, the $i is used as a part of a loop routine which increases up to 5. 

       

      I need to increase the expansiveness of 'Fees' to include anything in the FilterTurnoverType field which includes the word 'Fees' in the description.  IIRC, on SQL I could have used the LIKE command with/or % markers either side.  I've struggled a little with this on here:

       

      Let ([

       

      CUST = Cust_Home::CustID_PK ;

      SQL = "Select SUM(TotalValue) from Values_Home where

       

      CustID_FK = ? and

      FilterTurnoverType = ? and

      PeriodNumber = ? "];

       

      ExecuteSQL ( SQL;"";"";CUST;"Fees";$i)

       

      )

       

      Thanks in advance