RE: Use SQL to convert numeric to char

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

I don't think that'll work as DB2 will try to convert it and fail.

I had a different scenario that may apply. A char column with binary data in
it (i.e. INTEGER).  I could not figure out a way to do it with SQL alone as
it would always try to convert thinking it's char data.

In essence both you and I were after raw data, but there is no way to tell
DB2 engine to give it to us raw (well, other than in a program variable, as
you say, your application works fine).

So, what I had to do is create a UDF that simply gives me the data raw (no
conversion).  Works great.

Elvis

Celebrating 10-Years of SQL Performance Excellence

-----Original Message-----
Subject: Re: Use SQL to convert numeric to char

Ron - try this:

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

- Steve

----- Original Message ----- 
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