How to exclude values, where values contains "(" paranthesis.

For example I tried,

Where Email not like '%(%' 

But I am keep getting an error.

An error occurred while checking the query syntax. Errors: An unmatched parenthesis occurs in the query.


You can try with a soql query like below:

select id, email from user where NOT(email LIKE '%(%')
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.