Trim()去掉串两边空格RTrim()去掉串右边空格LTrim()去掉串左边空格 select concat(RTrim(vend_name),'(',RTrim((vend_country),')') from vendors order by vend_name;