Need SQL statement 2

[LannyB]

I have a table CURTRAN with a column PRVPMT. I am trying to identify any numbers in the PRVPMT column that have more than 2 decimal places, i.e. 100.123

 

[SantaMufasa]

Lanny,

You can use a variant of this code:

select * from lanny;

     X
------
15.687
105.25

select * from lanny
where round(x,2) <> x;

     X
------
15.687

Let us know how you like this method.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Thargy]

Santa,

I was investigating the use of trunc, followed by a nasty cast to a string, followed by a length - yeeew!

Please accept a star for elegant simplicity.

Regards

T

Grinding away at things Oracular

 

[LannyB]

Thanks, Santa! Christmas came early and it's greatly appreciated.