Don Frazier

Don Frazier is a Senior Programmer at EDS. He has over 20 years experience in the Information Systems industry on platforms ranging from IBM mainframes to PCs. His experience ranges from IBM Assembler Language to C/C++ to Visual Basic and the .NET languages of C# and VB.NET. Microsoft certifications include MCSE, MCSD and MCDBA. Don’s current assignment is leading the development effort for a large personnel system. This system is web based with SQL Server data bases. When not hard at work creating software, Don enjoys mowing his yard, flying his stunt kite and juggling.

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

315 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

221 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

233 reads

Blogs

Data Saturday #8–Southwest US

By

I am very excited to announce that I will be speaking for Data Saturday...

Data Weekender v3.1

By

I am super excited about this new version of Data Weekender, coming up on...

Thanks Kathi and Mala

By

I have to thank Kathi and Mala for putting on the WIT Mental Health...

Read the latest Blogs

Forums

Checking Up on Vendors

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Checking Up on Vendors, which...

SQL 2016 - Need help with complex calculations based on paycodes - New Changes

By DiabloSlayer

Hello Friends, Posting this for help as the client made more requirement changes. I...

Daily Autocheck for SQL instances

By mtz676

[System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources() | SELECT ServerName | Format-Table -HideTableHeaders The above code is not returning all...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers