I am trying to filter out some query results to where it only shows items with 6 decimal places. I don't need it to round up or add 0's to the answer, just filter out anything that is 5 decimal places or below. My current query looks like this: (ex. if item is 199.54215 i dont want to see it but if it is 145.253146 i need it returned)
select TRA_CODPLANTA, TRA_WO, TRA_IMASTER, tra_codtipotransaccion, tra_Correlativo, TRA_INGRESOFECHA, abs(tra_cantidadparcial) as QTY from mw_tra_transaccion where FLOOR (Tra_cantidadparcial*100000) !=tra_cantidadparcial*100000 and substring(tra_imaster,1,2) not in ('CP','SG','PI','MR') and TRA_CODPLANTA not in ('4Q' , '5C' , '5V' , '8H' , '7W' , 'BD', 'DP') AND tra_INGRESOFECHA > @from_date and abs(tra_cantidadparcial) > 0.00000
Any assistance would be greatly appreciated!