Cacher is the code snippet organizer for pro developers

-- String truncate on length, but no chopping up of words allowed

SELECT SUBSTRING('Business Analist met focus op wet- en regelgeving', 1, 16);

-- http://stackoverflow.com/questions/6650605/string-truncate-on-length-but-no-chopping-up-of-words-allowed