PACK() user defined function

By Don Frazier, 2013/05/24

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 base. See Unpack() script if you need to go the other way.

Total article views: 178 | Views in the last 30 days: 3

FORUM

convert a number to decimal

FORUM

Select Decimal

Need Decimal() function

FORUM

Check given number

how to check the given number is decimal

FORUM

Money type with 5 decimals

I need to change the number of decimals to 5 on a Money data type field

FORUM

Decimal Truncation in division

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

PACK() user defined function

convert a number to decimal

Select Decimal

Check given number

Money type with 5 decimals

Decimal Truncation in division

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

You make SSC a better place

Already a member? Jump in: