I am also facing the same problem

I used varchar to store the value

Declare @val Varchar

set @val = '-3.16E-05'

Select cast(@val as decimal(38,10))

gives me a error...