Working with SQL Server Currency Fields
Written by Eric Smith, Northstar Computer Systems LLC
A user asked why, when retrieving a database field that is of type Currency, that no currency symbols are displayed. This is because the Currency data type in the database isn't designed to store the currency symbol. Instead, you can use the built-in FormatCurrency function to format the value using the regional settings of the server. This will make sure you show the value using the proper punctuation and symbols.
Keywords: [
Uncategorized ASP Tips
]
Publication Date: 2/1/2000
|