Re: Use SQL to convert numeric to char

["Steve Landess" <sjl_abc@xxxxxxxxxxx>]

Ron - try this:

Select cast(NUMFIELD as CHAR(7)) from YourFile

- Steve

----- Original Message ----- 
From: "Ron Adams" <rondadams@xxxxxxxxx>
To: <MIDRANGE-L@xxxxxxxxxxxx>
Sent: Friday, May 04, 2007 12:00 PM
Subject: Re: Use SQL to convert numeric to char


> The field is Packed 13,4.
>
>
>
> On 5/4/07, Ron Adams <rondadams@xxxxxxxxx> wrote:
> > I've got a weird one here.
> >
> > Some "clever" programmer decided to use a numeric field to store 
> > character
> > data. The coversion is handled just fine by the application program, but 
> > I
> > would like to be able to view the character data using SQL. How would I 
> > do
> > this?
> >
> > --
> > Ron Adams
>
>
>
> --
> Ron Adams
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.