Checks whether the contents of the specified column is NULL or that it is empty. The function returns TRUE (1) if a column is null or if its (string) length is zero. Otherwise returns FALSE (0). Currently only works with Strings.
SELECT * WHERE ISNULLOREMPTY(columnname)=FALSE|TRUE
See also: ISNULL.
/* Get all customers from the customer table where country is Denmark and where the customer name is
not NULL or empty */
SELECT * FROM Customer WHERE Country=’Denmark’ and ISNULLOREMPTY(CustomerName)=FALSE
Please sign in to leave a comment.