On Mar 20, 3:03 pm, DA Morgan <damor..._at_psoug.org> wrote:
> MattJ83 wrote:
> >> Why do you use CHAR, and not VARCHAR2?
> >> Why do you store a number in a character field?
>
> >> Sigh...
> >> --
> >> Regards,
> >> Frank van Bortel
>
> > Hi Frank,
>
> > I was using the CHAR field because i had characters in the field....i
> > wanted to get rid of these characters so that i could put the numbers
> > in a NUMBER field
>
> One has nothing to do with the other. Why are you using CHAR and not
> VARCHAR2?
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
My string is a fixed length.
Received on Fri Mar 23 2007 - 09:37:03 CDT
