The above is not DBMS-independent, since Sybase does not provide the trim function. However, the below approach will work both in Sybase and Oracle:
where rtrim(ltrim(product_type)) is nullOracle 判断为空 all space
标签：bms HERE however use 判断为空 pre product pac acl