Oops,
Forget to add the script of how the function is used on the table to get the required data.
SELECT * FROM #Temp
UPDATE #Temp SET Output = dbo.ufn_ExtractNumbersFromText(3,Data)
SELECT * FROM #Temp
Thanks
"I Love Walking In The Rain So No One Can See Me Crying ! " ~ Charlie Chaplin