Technical Article

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

240 reads

Blogs

Hello world!

By

Welcome to WordPress. This is your first post. Edit or delete it, then start...

Daily Coping 2 Dec 2021

By

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

SQL Homework – December 2021 – Changing collation

By

I can only speak for the locations I’ve worked at of course, but in...

Read the latest Blogs

Forums

SQL Query Help on Time based query

By dcw8888

I have a following table (Contains script to generate the sample table with data):...

When to Use a Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item When to Use a Database

SQL Server Data Masking: a comparison with Gallium Data

By maxtardiveau

Comments posted to this topic are about the item SQL Server Data Masking: a...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers