How do I limit the number of characters in memo field to 1000 on a saved search?

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.

Rookie Asked on March 2, 2021 in Saved Searches.
Add Comment
1 Answer(s)

I believe SUBSTR() should work here, just google Oracle SUBSTR for syntax details.

Intermediate Answered on March 2, 2021.

Got it!  Thank you!

on March 2, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor