用列中最长数据的长度设置子字符串长度

I am doing a substring to get all the email address matching a certain Expense Code. Since I don't know ahead of time what will be the max length I always use a way too big int and I wonder if it would affect the performance of the query.I am doing a substring to get all the email add