What is the best way to remove the decimal from a number? Convert 123.30 to 12330
M MA May 19, 2004 #1 What is the best way to remove the decimal from a number? Convert 123.30 to 12330
R RobFMS May 19, 2004 #2 In this case, I would suggest using the REPLACE() function. That is: Replace ( "123.30", ".", "") -- Rob FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
In this case, I would suggest using the REPLACE() function. That is: Replace ( "123.30", ".", "") -- Rob FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
M Michelle May 19, 2004 #3 If it's a number field, not text/string, you can just multiply the value times 100.
