Here's one way...

--sample data

declare @t table (s varchar(100))

insert @t

select 'ANALYSIS RECORDS (APPROX 100 PPS)'

union all select 'REVIEW MANUAL (75+ PAGES)'

union all select 'Number 11'

union all select '1 way'

union all select '7'

--calculation

select s, substring(s2, 0, j) as Number from (

select *, patindex('%[^0-9]%', s2 + 'x') as j from (

select *, substring(s, i, 100) as s2 from (

select *, patindex('%[0-9]%', s) as i from @t) a) b) c

/* results

s Number

---------------------------------------- --------

ANALYSIS RECORDS (APPROX 100 PPS) 100

REVIEW MANUAL (75+ PAGES) 75

Number 11 11

1 way 1

7 7

*/