The one answer I see here doesnt work for me but I am using T-SQL so maybe this is for some other database outside of MS SQL Server. Anyhow for T-SQL this should work
CASE WHEN LEN(EmailAddresses) > 50 THEN SUBSTRING(EmailAddresses, 1, 47) + '...' ELSE EmailAddresses END AS EmailAddresses