>Hi
>
>Any suggestions on the best way to return a string with all the non numeric characters removed in SQL2008 R2
>
>Thanks
>
>Nick

Use 10 nested REPLACE statements.

Actually, I misread. I thought you wanted to remove numbers and keep everything else.

If you want to remove all except numbers, check

http://blogs.lessthandot.com/index.php/datamgmt/datadesign/extracting-numbers-with-sql-server/