Hi,
I have the following conditional prompt in my sql which works well.
trim(custid) in (#promptmany('CustomerID','string',sq('Not Selected'))#)
I need to extend it so that if CustomerID is null or not set that it includes all customers.
Whats the best way to do this?