Don Frazier

zPad() - add leading zeros to a number

This user-defined function converts a number to character format and adds leading zeroes to pad the field to a specified length.  useful for displaying SSNs or other numeric fields where the leading 0's are significant but the field is stored as numeric.To use:select dbo.zPad(, )make sure your length includes an extra column for the sign.  […]

2002-12-05

284 reads

Convert a number to words

This is a handy function that converts a  number (integer) into its word format.  This might be handy if you need to print a check formatted number in words.  Currently it supports an integer but it would be almost nothing to convert to support a bigint or decimal.The components are1) a table named PlaceValue that […]

2002-12-04

206 reads

PACK() user defined function

Convert a decimal number to IBM EBCDIC packed decimal format.  If for some reason you need to export a number to IBM systems in native format, you can define a SQL Server field as binary(8) and Pack() your decimal number into it.  Then IBM mainframes and COBOL/CICS systems can read the numbers from your data […]

5 (1)

2002-12-04

208 reads

Blogs

Azure SQL Database – Azure Portal Updates

By

A small but useful change has been made to the Azure Portal for Data...

SQL Server Quick Tips

By

Earlier this year I made a series of videos that were played before the...

The 2019 State of DevOps Report–Webinar

By

Tomorrow I get to chat with another giant in the world of DevOps: Jez...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Tsql/SP Code Optimization

By sizal0234

Hi, I am working on optimizing some of Tsql code for SP's. I know...

Powershell

By sizal0234

Does PS help in performance. Like instead of TSQL code used in sql agent...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers