Retrieve (Get) MAX value of FLOAT values in VARCHAR Column in SQL Server

Hi AbdulHaque,

The query gives correct result.

You are wrong with the logic. 

1.9 (considered as 1.90) which is greater than 1.10.

If you want 1.09 to compare instead of 1.90 then you need to change the saving code.

hi @dharmendr

Thanks for the wonderful explanation. The SQL Query below helped me to achieve my requirement.

select concat((select distinct case when CHARINDEX('.', SrNo) > 0 
then SUBSTRING(SrNo, 0, CHARINDEX('.', SrNo)) else SUBSTRING(SRNO, CHARINDEX('.', SrNo) + 1, LEN(SRNO)) end 
from tbl_Material_Req where Req_No = '"+ s_reqNo + "'),'.' , max( case when CHARINDEX('.', SrNo) > 0 then CAST(SUBSTRING(SRNO, CHARINDEX('.', SrNo) + 1, LEN(SRNO)) AS int) else 0 end )) as srno from tbl_Material_Req where Req_No = '"+ s_reqNo + "'