3 Replies Latest reply on Mar 24, 2015 9:42 AM by philmodjunk

    ExecuteSQL NOT LIKE function

    sccardais

      Title

      ExecuteSQL NOT LIKE function

      Post

      I want to create a list of unique OrgID's from a table TO1_IMPORTS where the substring "Support" is not in the field UserID.

      The query below is not filtering out the records from TO1_IMPORTS that have this string in the UserID field. (e.g. the query includes OrgID's that have this string in the UserID field).

      ExecuteSQL ("SELECT DISTINCT OrgID FROM TO1_IMPORTS WHERE UserID NOT LIKE '%Support' " ; "" ; "")

      Can anyone tell me what's wrong with this query?