Points: 7253

2/6/2019 10:33:28 AM

Remove unwanted characters from a field in SQL

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

Got a request in today to remove special characters from a field in a SQL table. The result was slightly more verbose than I thought it would be, but it's still 'article worthy'

Here we go...

Version: All
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables