<div>
How do I get rid of double qoutes and single qoutes?<br />
It works fine with ` but gives error on double qoutes and single qoutes.<br />
Thanks much.
</div>


How do I get rid of double qoutes and single qoutes?
It works fine with ` but gives error on double qoutes and single qoutes.
Thanks much.

<div>
single quotes:<br />
replace(fieldname, '''', '')<br />
<br />
double quotes:<br />
<br />
replace(fieldname, '''''', '')<br />

</div>


single quotes:
replace(fieldname, '''', '')

double quotes:

replace(fieldname, '''''', '')


<div>
Sorry guys, I have to keep the single qoutes/double qoutes and all the speical characters in there and then sort it. Is there any way to not to take them out but ignore them while sorthing.<br />
<br />
Thanks much.
</div>


Sorry guys, I have to keep the single qoutes/double qoutes and all the speical characters in there and then sort it. Is there any way to not to take them out but ignore them while sorthing.

Thanks much.

<div>
You're not taking them out...you're just taking them out of the sort....just like angelIII showed you. &nbsp;You're ignoring them....make sure your REPLACE statement is after the ORDER BY clause.<br />

</div>


You're not taking them out...you're just taking them out of the sort....just like angelIII showed you.  You're ignoring them....make sure your REPLACE statement is after the ORDER BY clause.


<div>
<div class="content wysiwyg-content">
I am trying to sort a field that has special characters in them .i.e. `, &quot;, ' etc<br />
When I sort the results, the records with special characters always show up first, is there any way to ignore special characters during the sort, in SQL Server maybe? or in PHP if not.<br />
<br />
Thanks.<br />

<pre><code id="code-114130">.i.e. `, &quot;, ' etc
</code></pre>
</div>
</div>


I am trying to sort a field that has special characters in them .i.e. `, ", ' etc
When I sort the results, the records with special characters always show up first, is there any way to ignore special characters during the sort, in SQL Server maybe? or in PHP if not.

Thanks.

How to sort an nvarchar field that contains special characters

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

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.