Insert into float field

[solo1234]

Dear all,

We have a string (float value) (komma as decimal sign) and we want this string into a floating field.

We tried:

insert into DB (floatField) values (CONVERT(DECIMAL('12,1')))
insert into DB (floatField) values (cast('12,1' as double))
insert into DB (floatField) values (cast('12,1' as decimal))

These examples doesn't work, can someone give the right syntax?

Nice regards,
Michelle.

 

[SQLSister]

Well have you tried replacing the comma with a decimal?

Also float is a very bad type of data type to use if you ever want to do calculations on the number as it is inexact and will introduce rounding issues. Perhaps you would be better served by changing the datatype to a decimal datatype.


"NOTHING is more important in a database than integrity." ESquared