You can use trim on the column.
where trim(product_type) is nullThe 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 null原文：https://www.cnblogs.com/kakaisgood/p/10059883.html