Regulat expression s might help you.
Unfortunatelly (among others) regexp is not built in in sql server, but you can have it:
xp_pcre - Regular Expressions in T-SQL[
^]
Regular Expressions in MS SQL Server 2005/2008[
^]
You will also need to split the values in that field that match with the cell phone pattern, whatever that would be. This can be also done:
http://ole.michelsen.dk/blog/split-string-to-table-using-transact-sql.html[
^]
Still it looks better to either create a
proper CLR function[
^] that does the splitting and the filtering and it is returning only the desired values as table (even formatted identically) - or to move this functionality in an upper layes, as SA suggested.