Dinesh thykkalat 0 Posted Tuesday at 09:48 AM Report Share Posted Tuesday at 09:48 AM 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 133 Posted yesterday at 01:26 AM Report Share Posted yesterday at 01:26 AM 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.