Here is an example of the TABLE that I have:
ID | Locale | GUID
088 US tasffsddf124312
088 US tasffsd321123
I want to be able to ONLY select users WITH data in the GUID-column and exclude the ones with no data in the GUI-column.
Here is what I have:
SELECT * FROM table_name WHERE TACTIC_ID = '0088' AND LOCALE = 'US' AND ACTIVE = '1' AND TRIM(IFNULL(GUID, '')) <> ''
This does not work in Marketing Cloud.