I have a long text area field which in some cases has characters that cause problems e.g. Vertical Tabs. I need to find all instances where the field contains such a character I can't write a SOQL query to check this because you can't check for a long text area in a SOQL query.

So any tips how I could do this?

Thinking I might have to go via APEX.

Any other ideas?