<div>
<pre><code class="code-10 nolinks" id="code-20-41453664-1"><span>CREATE FUNCTION dbo.udf_DigitsOnly (@strToFix varchar(80))</span>
<span>RETURNS varchar(80)</span>
<span>AS</span>
<span>BEGIN</span>
<span>	DECLARE @intWanted int</span>
<span>	SET @intWanted = PATINDEX('%[^0-9]%', @strToFix)</span>
<span>	BEGIN</span>
<span>		WHILE @intWanted &gt; 0</span>
<span>		BEGIN</span>
<span>			SET @strToFix = STUFF(@strToFix, @intWanted, 1, '')</span>
<span>			SET @intWanted = PATINDEX('%[^0-9]%', @strToFix)</span>
<span>		END</span>
<span>	END</span>
<span>	RETURN @strToFix</span>
<span>END</span>
<span>;</span>
</code></pre>
<br />
use it like this:<br />
select dbo.udf_DigitsOnly ('+61 555 ab76) 23 0')<br />
<br />
<br />
result:<br />
<br />
6155576230<br />
<br />
see <a href="http://sqlfiddle.com/#!6/44fe4/1" rel="ugc">http://sqlfiddle.com/#!6/44fe4/1</a>
</div>


<div>
The function then is saved in the DB and I call it in the select statement ?
</div>


<div>
Works like a charm ! &nbsp;I assume I can call the function from the ASP page, correct ?
</div>


<div>
You should be able to call from ASP<br />
<br />
But i am not an ASP user
</div>


<div>
Its ok. ill test tonight &nbsp;:)
</div>


<div>
<div class="content wysiwyg-content">
I have a phone number inside a field called 'phone'<br />
I need to remove all formatting (parenthesis, dashes, spaces) and leave the numbers only.<br />
<br />
I have the sql below but it only removes dashes, can I get help to remove everything but digits ? &nbsp; or to additionally remove parenthesis open and close and spaces ?<br />
<br />
Replace(PobCountry,'-','')<wbr /> AS phoneclear
</div>
</div>


I have a phone number inside a field called 'phone'
I need to remove all formatting (parenthesis, dashes, spaces) and leave the numbers only.

I have the sql below but it only removes dashes, can I get help to remove everything but digits ?   or to additionally remove parenthesis open and close and spaces ?

Replace(PobCountry,'-','') AS phoneclear

remove parenthesis, spaces and dashes

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.

Web Development

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.