SQL SERVER将字段的空格都去掉

SQL SERVER函数：

LTRIM()

RTRIM()

注意没有TRIM

 

今天做东西时，遇到了

SELECT LTRIM(RTRIM(item_name)) AS item_name FROM FM_CODE_LIST WHERE FORM_KIND='SYS' AND FIELD_NAME='部门中文名称' and (upper(ITEM_NAME) like 'G%') order by item_name