AnsweredAssumed Answered

ExecuteSQL NOT LIKE function

Question asked by sccardais on Mar 24, 2015
Latest reply on Mar 24, 2015 by philmodjunk

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?

 

Outcomes