How to filter by substring?

For example, in Azure Storage Explorer I want to select only records with a certain field containing say a word
"exception" where the word might be anywhere in that field (not just at the beginning). How to accomplish that?