Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Convert Currency to English

By Admire Tofa,

Just plug this into your Query Analyser and play. This code is an easier way of converting currency to English which can be altered easily to suit your needs.

I found that this script will help in avoiding the storage of Amount in Words everytime an amount is stored in applicatons that require the functionality.

Total article views: 168 | Views in the last 30 days: 1