Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Mobile Phone Numbers

Author  Topic 

sprice@sector-uk.com
Starting Member

1 Post

Posted - 2005-03-22 : 06:50:40
Anyone got some SQL to extract UK Mobile Phone Numbers (07......) from a text field?

dev45
Yak Posting Veteran

54 Posts

Posted - 2005-03-22 : 07:24:15
maybe u can tell us how the current format of the data
Do u have a text field and pass its value to an sql stored procedure?
(take a look at charindex and patindex in BOL)
Go to Top of Page
   

- Advertisement -