<div>
<div class="content wysiwyg-content">
I want to automatically remove commas from a column in a frequently updated table. &nbsp;Can I do this using an update query attached to a button or code. &nbsp; what code or sql would I use?
</div>
</div>


I want to automatically remove commas from a column in a frequently updated table.  Can I do this using an update query attached to a button or code.   what code or sql would I use?

Access 2007 use vba code or query to remove commas from a column in a table

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

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

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.