scrub_non_numeric.sql

SELECT *
FROM 
( 
	SELECT 
		STUFF(( 
		SELECT '' + comp.entity_data AS [text()]
		FROM (
			SELECT 
				DISTINCT 
				number		
			FROM master..spt_values AS v 
			WHERE
				v.number BETWEEN 1 and LEN(o.name)		
	) AS num
	CROSS APPLY 
	(
		SELECT 
			SUBSTRING(o.name, num.number, 1) AS entity_data		
	) AS comp
	WHERE 
		comp.entity_data IN
		(
			'0',
			'1',
			'2',
			'3',
			'4',
			'5',
			'6',
			'7',
			'8',
			'9'
		)
		FOR XML PATH('') ), 1, 0, '' ) AS res,
		o.object_id
	FROM sys.objects AS o    
) AS f
WHERE 
	f.res IS NOT NULL 

SELECT name, object_id  
FROM sys.objects
where name like '%[0-9]%'