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
*/
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.