I think this handles all values that will convert to float (except those that use 'D' for scientific notation):

create function dbo.fn_to_number

(

@num varchar(64)...