SQLServerCentral / SQL Server 2005 / Development / I need to convert integer into decimal by specifying the decimal point / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 02:44:25 GMT20RE: I need to convert integer into decimal by specifying the decimal pointhttp://www.sqlservercentral.com/Forums/Topic1420677-145-1.aspxYes, I just did it.Thank you.Fri, 15 Feb 2013 10:59:40 GMTShree-903371RE: I need to convert integer into decimal by specifying the decimal pointhttp://www.sqlservercentral.com/Forums/Topic1420677-145-1.aspxLike this?[code]update #X set Samp = Samp / 100000[/code]Fri, 15 Feb 2013 10:58:03 GMTSean LangeI need to convert integer into decimal by specifying the decimal pointhttp://www.sqlservercentral.com/Forums/Topic1420677-145-1.aspxHello, I need to convert an integer into decimal by specifying the decimal point.For example, if i have 0000318750, when i try to convert into decimal it gives me 318750.00, but i need it to be 3.18750.Can this be done? Thanks in adavance.CREATE TABLE #X (Samp decimal(15,5));INSERT INTO #X VALUES ('0000318750')SELECT * FROM #XFri, 15 Feb 2013 10:43:24 GMTShree-903371