How to replace all numbers of exactly 8 characters in length eg 12345678

I've done a good bit of searching all over so don't berate me yet.

I have a column with string values showing the name of shows.

Eg:

[Titles]

World Cup 2014

Family Guy

UFC Fight Night

9pm News and Weather

2014 Media Awards

Homeland 2524232

Simpsons 2524231

Shameless

Soccer Night 4534232 International

Rugby Live 4534232 HTML5

I wish to use a select statement to strip out the numbers where the numbers are exactly 8 characters in length.

I have only read access so cannot create functions and im using SQL Server 2005.

Cheers.