<div>
<br />
<br />
Function stripNonNumeric(vString As String) As Long<br />
Dim j As Integer, vNum<br />
If Len(vString) = 0 Then Exit Function<br />
For j = 1 To Len(vString)<br />
&nbsp; &nbsp; &nbsp; &nbsp;If IsNumeric(mid(vString, j, 1)) Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;vNum = vNum &amp;&nbsp;mid(vString, j, 1)<br />
&nbsp; &nbsp; &nbsp; &nbsp;End If<br />
Next<br />
<br />
If Len(vNum) &gt;&nbsp;0 Then<br />
&nbsp; &nbsp;stripNonNumeric = vNum<br />
End If<br />
<br />
End Function<br />
<br />
<br />
to use in a query<br />
<br />
select stripNonNumeric([Phone]) fromtablex<br />
<br />
<br />
<br />

</div>


<div>
if u hit alt-f11 it takes u to the vba editor<br />
in the projects pane, right click, select insert then module<br />
<br />
now paste your function here, ensure it is defined as &nbsp; public function<br />
<br />
then save this<br />
<br />
one this is saved u can use it in your query but only if its saved<br />
<br />

</div>


<div>
Pray tell, what has this question got to do with MS SQL Server, let alone MySQL?
</div>


<div>
capricorn1 - I tried your code but I got a &quot;run time err 6, overflow&quot;. Apologies if it was the result of my implementation but rockiroads gave me the additional &nbsp;vba pointers which I was looking for.<br />
<br />
acperkins - the reason I posted where I did was I wanted to select the max 3 forums and I figured an expert in any of those forums would be able to answer my sql question. Since I have only recently begun asking questions, I'd welcome suggestions as to more logical choices when I have Q's on MSAccess (they'll generally be sql query related).
</div>


<div>
&gt;&gt;I'd welcome suggestions as to more logical choices when I have Q's on MSAccess (they'll generally be sql query related).&lt;&lt;<br />
Simply put the SQL dialect used in MS Access is similar but not the same as MS SQL Server. &nbsp;So adding MS SQL Server to the zones will provide you with solutions you cannot use. &nbsp;You could just as well hace added MySQL pr Oracle or DB2, for all the good it will do you.
</div>


<div>
<div class="content wysiwyg-content">
I have a query that displays phone numbers and they have mixed in various brackets, spaces and dashes. I need to remove any special characters like that and just have the numbers displayed (i.e. 1231231234).<br />
<br />
The solution that I did find involves pasting code into a public function which I don't know how to do.
</div>
</div>


I have a query that displays phone numbers and they have mixed in various brackets, spaces and dashes. I need to remove any special characters like that and just have the numbers displayed (i.e. 1231231234).

The solution that I did find involves pasting code into a public function which I don't know how to do.

Edit MSAccess query to clean up phone field

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.