Hi,
I have a index on a 'number' column. As this column has very large values, it shows in exponentials when I make a select statement(shows a 5.173E+10 for a value
5173059437517)

Now I want to delete this particular record .so when I say
delete from table
where col_name = 5173059437517, it deletes 0 recors.

if i say
delete from table
where to_char(col_name) = to_char(5173059437517),
it's not making use of index.

1) So How do I delete this record.
2) If i convert the datatype of a indexed column for quering, will it still use the indexes.
Badrinath