There have been some posts on cleaning text with TSQL, Remove all non-numeric characters from a string and extract-only-numbers-from-a-string Here is my take on it. The nice thing is that you just specify the valid characters in the like pattern to select those that you want.return. declare @string varchar...