Re: to_Char or not to_Char

From: DL <donlcs_at_yahoo.com>
Date: 13 Jun 2002 13:29:45 -0700
Message-ID: <604bb90c.0206131229.291c98c0_at_posting.google.com>


I see your point on the data comparison side, and thanks for that, but I don't think it has got anything to do with a data model.

DL

postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<a20d28ee.0206122336.6a2e304e_at_posting.google.com>...
> donlcs_at_yahoo.com (DL) wrote in message news:<604bb90c.0206121235.60d006a6_at_posting.google.com>...
> > Hello,
> >
> > I'm doing something like this in the Where clause of SQL statement:
> > to_Char(float_datatype_Column) < '2724.3837'
> >
> > in another similar statement,
> > to_Char(float_datatype_Column) < '2724.3837+e'
> >
> > I'm just wondering if this would mess up the data comparison for the
> > "float" data type, in other words, if the comprison would be precise.
> >
> > Well, the reason I'm using to_Char in the above case is that the SQL
> > statement could also be:
> > to_Char(varchar2_column) LIKE 'Gone with Wind'
> >
> >
> > Thank you in advance.
> >
> > DL
>
> You are comparing strings here, aren't you?
> Doesn't that say it all?
> Obviously, this is a lousy datamodel.
>
> Hth
>
> Sybrand Bakker
> Senior Oracle DBA
Received on Thu Jun 13 2002 - 22:29:45 CEST

Original text of this message