Dec 21, 2002 #1 mooniron Programmer Dec 15, 2002 26 TR Can anybody help about how to convert from char to currency
Dec 21, 2002 #2 tlbroadbent MIS Mar 16, 2001 9,982 US Use the CONVERT function to convert character data to MONEY. The character data must be numeric. Convert(money, char_column) Terry L. Broadbent - DBA SQL Server Page: http://tlbroadbent.home.attbi.com/sql/sql_articles.htm If you want to get the best answer for your question read faq183-874. Upvote 0 Downvote
Use the CONVERT function to convert character data to MONEY. The character data must be numeric. Convert(money, char_column) Terry L. Broadbent - DBA SQL Server Page: http://tlbroadbent.home.attbi.com/sql/sql_articles.htm If you want to get the best answer for your question read faq183-874.