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
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