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

288 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

209 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

209 reads

Blogs

Microsoft Tools That Help Query Tuning

By

Query tuning is not easy. In fact, for a lot of people, you shouldn’t...

Author of the Year 2019 Nomination at MSSQLTips

By

This year I’ve been nominated again for the Author of the Year award at...

Extended Events Misperceptions: Profiler is Easier

By

I know, I know, I’m on #teamexevents so I think that Extended Events can...

Read the latest Blogs

Forums

Transcation Log Backup Restoration Time

By Harshana-455711

Hi Is anyone know please advice, how much time will take for restoration 250GB...

Slimymed

By ouhgqabhugop

https takeapills com/slimymed-de/  

Update 22/01/2020 - ICQ678924920 => Sell Credit Card/DeadFullz/Gifts Card

By jack678924920

Hi guys! Call me Jack.. Update 22/01/2020 12:04 PM LIST CREDIT CARD AND GIFT...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers