Hi,
The best way in my opinion would be to use Regex and some CLR functions to replace the characters. Read this article:
http://www.simple-talk.com/sql/t-sql-programming/clr-assembly-regex-functions-for-sql-server-by-example/[/url]
Once you've got the functions installed then it's as simple as:
SELECT dbo.RegExReplace('ABC123ABC','[A-Z]','')