InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 00:05:42 GMT20http://www.sqlservercentral.com/Forums/Topic896468-392-1.aspxSee:[u][url=http://msdn.microsoft.com/en-us/library/ms188688.aspx]Using Monetary Data[/url][/u][u][url=http://msdn.microsoft.com/en-us/library/ms179882.aspx]Money and SmallMoney[/url][/u]Example:[code="sql"]SELECT $123.67[/code]Sun, 04 Apr 2010 14:25:08 GMTPaul Whitehttp://www.sqlservercentral.com/Forums/Topic896468-392-1.aspxHeh... "fuzzy, forgiving input" that disregards just about all currency marks other than the decimal point except when set to the European format where periods represent commas and a comma is the decimal point.Look at it this way... "It's not a fault, it's a feature." ;-)Sun, 04 Apr 2010 14:22:39 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic896468-392-1.aspxHiCan someone explain what is money datatype..select CONVERT(money,'1,0,0,0,0,0,0.0,0,0,1')RegardsVMSSanthoshSun, 04 Apr 2010 14:10:46 GMTvmssanthosh