Dinesh thykkalat 0 Posted January 12 Report Share Posted January 12 result of SELECT STR(39.775,15,2); have doubts result should be 39.78 but its output is 39.77 Quote Link to post Share on other sites
niche 139 Posted January 14 Report Share Posted January 14 After playing around with that function at https://www.w3schools.com/sql/trysqlserver.asp?filename=trysql_func_sqlserver_str2 , the function obviously has a rounding feature. Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.