Convert Currency to English

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.

2006-03-27 (first published: )

224 reads

Blogs

T-SQL Tuesday Retrospective #015: Automation

By

In February 2011, Pat Wright invited us to talk about Automation: So the topic...

Daily Coping 12 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Updated Pluralsight Course – Managing the Kubernetes API Server and Pods

By

My updated course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! If...

Read the latest Blogs

Forums

SQL 2012 Standard - Index highly fragmented

By mjbc

Hi there, Complete newb.  Need some guidance. Running SQL 2012, running INFOR ERP.  Indexes...

Manual tasks in SSIS design

By Roust_m

Hi, I am getting CSV files with hundreds of columns many of which have...

Loading a csv file into sql server table

By Roust_m

Hi, I've created a simple dataflow with flat file source and sql server destination....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers