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

Don't know much about SQL but sounds like using CLR with a regex might be a good solution......