Have you tried to dump the column? See the example below (due to my language settings the decimal point is showing up as a comma.) SQL> describe t Nom NULL ? Type ------------------- -------- ------------- N NUMBER(9,2) SQL> column n_dump format a40 SQL> select n, dump (n) as n_dump from t ; N N_DUMP --------- ---------------------------------------- -,02 Typ=2 Len=3: 63,99,102 -,01 Typ=2 Len=3: 63,100,102 0 Typ=2 Len=1: 128 ,01 Typ=2 Len=2: 192,2 ,02 Typ=2 Len=2: 192,3 > -----Original Message----- > Stephen.Lee@xxxxxxxx > > OK folks, this column is a number(9,2). > Can anybody explain how to make this happen? > I've tried stuff like > > (to_number('-.00') > -0.01 / 4 > 0 - 0.00500001 > > I can't make it happen. Any ideas? > I'm thinking I'm hearing the voice of Rod Serling right about now. > > select amt from incident_detail where rowid in (select rowid from > ftladm.incident_detail where to_char(amt) = '-.00') > SQL> / > > AMT > ---------- > -.00 > -.00 > -.00 > -.00 > -.00 > -.00 > -.00 > -.00 > -.00 > -.00 > -.00 > -.00 > -.00 > -.00 > -.00 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------