Trim()去掉串两边空格
    RTrim()去掉串右边空格
    LTrim()去掉串左边空格

    1. select concat(RTrim(vend_name),'(',RTrim((vend_country),')') from vendors order by vend_name;