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: )

182 reads

Blogs

Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - Part 2

By

(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for...

Extended Events Misperceptions: Profiler is Easier, Part 2

By

I wrote a short blog post about the misperception that Profiler was easier than...

CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))

By

If you read the title to this post and your first thought was That’s...

Read the latest Blogs

Forums

Replication question

By pani

Im an Oracle DBA by trade and been tasked with setting up transaction replication...

Software to send Report

By VastSQL

Hi Experts, Currently we are using SQL Server and Database Mail to send reports...

DBCC showcontig help

By vicky

Hello Team, I am using DMV dm_db_index_physical_status to replace the DBCC is sql server...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers