Unpacking data from SQLVAR

["Buckridan, Stephanie" <Stephanie.Buckridan@xxxxxxxx>]

I'm a bit new to SQL and have managed to create a dynamic variable column
sql program.  I can retrieve the character fields with no problems, but am
coming unstuck with the packed/zoned data.

I have retrieved the data into a long data structure in order to parse it
out and have managed to get the precision and scale of the numeric field
into a usable version.  I need to know how to parse the packed/zoned data
out of the data structure and then move to the next column's data.

Any help/examples would be greatly appreciated.

Thanks
Steph


----------------------------------------------------------------------
If you have received this e-mail in error or wish to read our e-mail 
disclaimer statement and monitoring policy, please refer to 
http://www.drkw.com/disc/email/ or contact the sender.
----------------------------------------------------------------------