--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
*/

declare @t table (s varchar(100))
insert @t (s)
          select 'ANALYSIS RECORDS ON 1/1/2008 (APPROX 100 PPS)'
union all select 'REVIEW MANUAL (750+ PAGES)'
union all select 'ANALYSIS RECORDS (APPROX 108 PPS)'
union all select 'REVIEW MANUAL (78+ PAGES)'

select case when patindex('%PPS)%',s) > 0 then substring(s, patindex('% PPS)%',s) -
                                                              patindex('%[^0-9]%',
                                                               reverse(
                                                                 left(s, patindex('% PPS)%',s)-1 )
                                                               ) 
                                                             ) + 1 ,len(s) - patindex('% PPS)%',s)-1 
                                                           )
            when patindex('%PAGES)%',s) > 0 then  replace(substring(s, patindex('% PAGES)%',s) -
                                                              patindex('%[^0-9+]%',
                                                               reverse(
                                                                 left(s, patindex('% PAGES)%',s)-1 )
                                                               ) 
                                                             ) + 1 ,len(s) - patindex('% PAGES)%',s)-2 
                                                           ),'+','')
       else '-1' end , s
from  @t

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

You can check my BLOG here