If you are using SQL Server 2005 you could create a CLR stored procedure to perform RegExMatch and only match [0-9]+.

The code that I posted is essentially the split function, so you could just include that in your query if you cannot create stored procedures or functions.  You could also...

You could perform the split yourself, something like the following...

declare

@input varchar(1000)

set

@input