# Use SQL to Copy Column Values with CData Drivers

**URL:** <https://community.cdata.com/t/use-sql-to-copy-column-values-with-cdata-drivers/1170>\
**Category:** CData Drivers\
**Tags:** discussion, driver, odbc\
**Created:** [August 21, 2025, 8:37am UTC](https://community.cdata.com/t/use-sql-to-copy-column-values-with-cdata-drivers/1170 "2025-08-21T08:37:44Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mohsin](https://avatars.discourse-cdn.com/v4/letter/m/41988e/32.png) [@Mohsin](https://community.cdata.com/u/Mohsin)\
**Post date:** [August 21, 2025, 8:37am UTC](https://community.cdata.com/t/use-sql-to-copy-column-values-with-cdata-drivers/1170/1 "2025-08-21T08:37:44Z")

</div>

Need to update one column with values from another? You can do it directly with CData Drivers using standard SQL.

We show how to run an `UPDATE` statement against live SaaS and database sources—no exports, no workarounds. The example uses our ODBC Driver for Salesforce, but the same approach works across all drivers that support `UPDATE`.

This is useful for data cleanup, migration, or quick edits—especially in SaaS environments where this kind of operation is often difficult.

📖 [Full blog here](https://www.cdata.com/kb/articles/execute-sql-statements.rst)

Got a question or want to share how you’re using SQL with CData Drivers? Drop it below.