to_Char or not to_Char

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 Received on Wed Jun 12 2002 - 22:35:56 CEST