# Another easy one for the experienced

**URL:** <https://forum.kirupa.com/t/another-easy-one-for-the-experienced/68638>\
**Category:** Uncategorized\
**Created:** [October 27, 2004, 3:26pm UTC](https://forum.kirupa.com/t/another-easy-one-for-the-experienced/68638 "2004-10-27T15:26:48Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![GFX\_Wiz](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/gfx_wiz/32/815_2.png) [@GFX\_Wiz](https://forum.kirupa.com/u/GFX_Wiz)\
**Post date:** [October 27, 2004, 3:26pm UTC](https://forum.kirupa.com/t/another-easy-one-for-the-experienced/68638/1 "2004-10-27T15:26:48Z")

</div>

This one should be easy for anyone other than me…I couldn’t find any documentation on the 'net for this…

When I query the database I get my results. One of the results is a headline that can be up to 255 characters in the database. However, in some instances I only have enough room to display the first 35 characters. How can I truncate the output followed by a “…” if it’s longer than 35 characters?

example:

- in DB: “Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Mauris ipsum justo, fermentum ornare, pulvinar vel, ultrices ut, turpis.”

- required output: “Lorem ipsum dolor sit amet, consect…”

Thanks for any input!

peace,  
GFX.Wiz