General information
Category:
Coding, syntax & commands
Not really sure what I am doing wrong here. Anyhow I am trying to write an Select statement that will count a field which can either can be empty or completed. In my SQL statement I have COUNT(!EMPTY(subscriber.c_premiumproduct_id)) and COUNT(EMPTY(subscriber.c_premiumproduct_id)). When I run the the select statement I get the same result for both even though I know the result show be 0 for empty and 2 for !empty. Any idea what I made be doing wrong here!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only