Let's say we have a fixed area to display words or text and we do not simply want to truncate based on the number of characters because we do not want words to get cut in half.
We could do
How to design and install a brick or pavers walkw...
Ideally, we would want
How to design and install a brick or pavers...
Anyone know of a quick and simple way to do this. I know how to
<CFSET desctrunc = LEFT(description,34)> but obviously that is based on characters.