DataLength(PROCESS_MANAGE_CODE) >0 过滤掉空值和空字符串的数据

select distinct PROCESS_MANAGE_CODE as process_manage_code from PRO_BOM_INFO  where PRODUCT_CODE=#{productCode} and DataLength(PROCESS_MANAGE_CODE) >0 and IS_DELETED='0' 
posted @ 2022-07-21 11:43  江南小镇的一缕阳光  阅读(25)  评论(0)    收藏  举报