Thanks to all.

I go through the link , now my issue with the decimal data type

SELECT col1 FROM table2

WHERE col2 > 9999999999.99999

OR col1 < -9999999999.99999

In this script col1 is primary key and col2 is the column from eroor.

The same thing i checked for my issue,some tables doesn't have any column with primary key, and some tables have clumn primary key but its datatype is int not decimal .

suggest me how to get data_purity values using the above script ..

Col1 and col2 should be same data type (decimal)??

Lavanyasri