| Subject | Re: [firebird-support] select and typecast data |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-10-16T16:49:16Z |
At 06:37 PM 16/10/2003 +0200, you wrote:
Let's say I want to typecast an integer to a varchar. I need a varchar
long enough to take the biggest integer I have stored. Let's say it's 7
bytes. Then I do
select cast(myinteger as varchar(7)) as myIntToString
from mytable
hth
Helen
>Helen Borrie wrote:And the next question is - what do you want to typecast as what?
>
> > At 06:18 PM 16/10/2003 +0200, you wrote:
> > >Helo!
> > >
> > >It is possible to typecast selected data???
> >
> > Yes.
> > Now, I wonder what the next question will be...
>
>Yes the next question is HOW :)
Let's say I want to typecast an integer to a varchar. I need a varchar
long enough to take the biggest integer I have stored. Let's say it's 7
bytes. Then I do
select cast(myinteger as varchar(7)) as myIntToString
from mytable
hth
Helen