Thanx Vijay ........

But this much is enough to find what I need ..

select MAX(len(FIELD NAME)-charindex('.',FIELD NAME,1) ) from TABLE NAME  

Thanx Again Dear,

Cheers,
-Hemant

Hi Hemant,

Try this.....

select max(len(substring(FIELD_NAME,charindex(".",FIELD_NAME,1)+1,len
(FIELD_NAME)-charindex(".",FIELD_NAME,1)))) from TABLE_NAME

A bit long query right? :-)

Cheers!!!
Vijay G

 Hemant Shivnani <hem_shiv@h...> wrote:Hi,
My problem is : I have a column of Varchar type which stores the numeric 
values eg. 434.53834 , 34.5 , 45.34, 34.0 .

I want to find the max size after the decimal of this data.

How can i do that ? I tried converting the value to float but the value is 
not properly getting coverted . eg. 54.563 gets converted to some 
54.56213132 which don't help in what i want.

Can any one help.

Thanx

Hemant
---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to 


---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now