filter

hi, most of a column values are like xx.00, how to find out the value have
more than 2 decimal (xx.001 or xx.xxx...) Thanks.Are the records not showing up or you only want the records that have more
than 2 decimal places?
What is the data type for the column?
HTH
Jerry
"js" <js@.someone@.hotmail.com> wrote in message
news:eDCvWkSyFHA.2348@.TK2MSFTNGP15.phx.gbl...
> hi, most of a column values are like xx.00, how to find out the value
> have more than 2 decimal (xx.001 or xx.xxx...) Thanks.
>|||What is the datatype of this column? Please include DDL in future so that we
don't have to guess. Try:
SELECT x
FROM t1
WHERE ROUND(x,2,1) <> x
David Portas
SQL Server MVP
--
"js" <js@.someone@.hotmail.com> wrote in message
news:eDCvWkSyFHA.2348@.TK2MSFTNGP15.phx.gbl...
> hi, most of a column values are like xx.00, how to find out the value
> have more than 2 decimal (xx.001 or xx.xxx...) Thanks.
>|||"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> Are the records not showing up or you only want the records that have more
> than 2 decimal places?
Yes. I only want to show the records have more than 2 decimal places.
> What is the data type for the column?
Real
Thanks.