SQL & PL/SQL

I'm trying to do the following:


SELECT COUNT (DISTINCT TEMP (IF TEMP <> '@')) FROM TABLE1 GROUP BY ORDER_NUM;


In other words I want to count, for each order number the number of unique/distinct temp values that are not equal to an '@' character.

Thanks in advance.