Functionality as same Val() function in Access in Sql Server

DECLARE @doc VARCHAR(256)
 
DECLARE @doctemp VARCHAR(256)
 
SET @doc='467 . 1 2 3 4 .5 6 7 8 9 0 6hhjjjj'
 
SET @doc = replace(@doc,' ','')
 
SET @doctemp = substring(@doc,charindex('.',@doc)+1,len(@doc))
 
SET @doctemp = substring(@doctemp,charindex('.',@doctemp),len(@doctemp))
 
SET @doc = substring(@doc,1,patindex('%'+@doctemp+'%',@doc)-1)
 
SELECT CASE
 
    WHEN @doc LIKE '[0-9.]%'
 
    THEN CAST(SUBSTRING(@doc, 1, PATINDEX('%[^0-9.]%', @doc+' ') - 1) AS FLOAT)
 
    ELSE 0
 
END