From this query, it looks like truncating and appending '...' looks fine.
select substring(agency_name,0,43), agency_name from agency where length(agency_name) > 43 ;
Greater Lowell Elder Mental Health Collabo...
From this query, it looks like truncating and appending '...' looks fine.
select substring( agency_ name,0, 43), agency_name from agency where length(agency_name) > 43 ;
Greater Lowell Elder Mental Health Collabo...