ExecuteSQL NOT LIKE function
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?