Home

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
Cancel
1 Answer(s)

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

Cancel
Intermediate Answered on March 2, 2021.

bweller

Got it!  Thank you!

on March 2, 2021.
Cancel
Add Comment
Cancel

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   Limebox   Become a Sponsor   Become a Sponsor