Hi Chris,

The reason, why I need to use type Char is that MS access doesnt work with Type float.For that reason I use Char.My entry for @e_Ncas is a number with comma. ( e.g. 15,79)

Of course when I change it to float it works but It doesnt solve my problem.

I only need to know how to convert char to float under SQL.Thats all.

Thank you

Peter