3 Replies Latest reply: Jun 22, 2011 1:51 AM by Gaurav Khare RSS

    Removing '-' from the output!

    Gaurav Khare

      Dear al,

      I have a simple query(though I' am not getting it right)...I have a table in which there are certain fields where in some cases their respective attributes are apparing as '-'  (hyphen)

      Now in that way my count of policy is appearing more than it is in actual, as I' am writing count(distinct Pol_ID)

      i have tried there various options like...suppress where the value is null etc etc.. but it's not working

      kindly help out