How to check if a text field is not null, not empty, doesn't contain white space in SOQL? Other than using something like,
AND (field__c != null AND field__c != '' AND Field__c != ' ')
in the WHERE clause of my SOQL, which isn't taking all the situations into account, how can I do this? I'm looking at the string class method such as,
I know I can iterate over the result of the query and filter out what I don't need but I'm asking this question to avoid that if possible to implement something within the query itself. Thanks!