thomasrushton

SQL Server DBA - part-time since 1995, full-time since 2010.

Function to express numeric value in words

There is a requirement here to take a number (such as 124995) and express it in words.  We needed a function to do this, as it would be used in an existing document generation system.I have developed the enclosed two functions to do this.  Note that the function does not, currently, cater for negative numbers, […]

2002-12-06

97 reads

Blogs

Microsoft Ignite Announcements 2021

By

Microsoft Ignite has always announced many new products and new product features, and this year...

Daily Coping 4 Mar 2021

By

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

Which configuration changes in SQL Server require a restart?

By

SQL Server is a complex beast, with many configuration options that can range from...

Read the latest Blogs

Forums

combine two interval tables into single result set

By rbroersma

Hello, Looking for help combining two interval tables together.  The tables are pretty simple......

How can do a loop select stmt from this folowing table

By aggy_02_20

Hi..How can do a loop statement for the following table first loop shld be...

buy Nembutal in china  W.h.a.t.s.ap.p +1(4.0.8) 8.3.7-1.8.2.9

By authenticcertificatesonline1

buy Nembutal in china  W.h.a.t.s.ap.p +1(4.0.8) 8.3.7-1.8.2.9, Buy Nembutal online in china, how to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers