> Does anyone know how to handle scientific notation in sql?
> i.e. 'insert into table value ( 5.e5-3 )'

This works for me using SQL Server 7 although I think the keyword is
VALUES.  Also, unless you define an appropriate column list, any VALUES
must be the same order and type as all columns in the table. (Do you
really have a table with a single float column?)

What DB are you using, and what error message are you getting?


Paul Ritchie
Radio Computing Services.
---------------------------------------------------------------------------
  New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz

Reply via email to