Re: to_Char or not to_Char

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 - 09:36:08 CEST