We are implementing a 3rd party software and they have a 1000 character limit. We have Memo’s with more than that so looking to truncate/ trim the number of characters returned on a saved search.
I believe SUBSTR() should work here, just google Oracle SUBSTR for syntax details.
Got it! Thank you!