I have a text field in my database that contains keywords associated with each company. Some companies went overboard. How can I delete all text that after 100 characters (counting spaces and any other characters).
Is there a way to find records that have more than 100 characters in my field?
I searched but all I found was setting a limit on the field (which I assume only works for new and not existing data)??