tag:blogger.com,1999:blog-14856085.post115400170734221230..comments2019-09-30T21:58:56.878-07:00Comments on Programmer Helper: A Fix() Function in T-SQLEdward Anil Josephhttp://www.blogger.com/profile/16692625715576750671noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-14856085.post-88565984760623210622008-11-06T22:38:00.000-08:002008-11-06T22:38:00.000-08:00The original source for this article is in the fol...The original source for this article is in the following link:<BR/>http://www.sqlservercentral.com/articles/Advanced+Querying/afixfunctionintsql/2487/<BR/><BR/>I just copied the article from sqlservercentral.comEdward Anil Josephhttps://www.blogger.com/profile/16692625715576750671noreply@blogger.comtag:blogger.com,1999:blog-14856085.post-83447467274867453842008-11-06T12:25:00.000-08:002008-11-06T12:25:00.000-08:00this is the only sig fig tutorial i could find tha...this is the only sig fig tutorial i could find that is both right AND explains the rationale. <BR/><BR/>One other way I know of to do this that might be a little more elegant is to convert to scientific notation, split on E, do a basic decimal round on the first part, then convert back to a regular decimal.<BR/><BR/>that would be good for doing it in regular application code, but your tsql solution is perfect for what I needed.<BR/><BR/>Thanks.Unknownhttps://www.blogger.com/profile/15060149139099484725noreply@blogger.com