I have a field with error messages that I need a case statement to cleanup for reporting. In this case some of the messages contain ID's which make the report long as each error has a unique ID. I want to lean this up by using something like eval error=case(like(error, "%DB Error"), "Database error", like(error, "%network Error", "Network Error"))... Etc. I am not getting the matches that I should be getting with this though, still the full errors are showing. Is there a better way to accomplish this?
... View more