# Underscore abbreviated fields in ODBC

**URL:** <https://the.fmsoup.org/t/underscore-abbreviated-fields-in-odbc/2791>\
**Category:** Questions\
**Tags:** xdbc\
**Created:** [February 22, 2022, 6:20pm UTC](https://the.fmsoup.org/t/underscore-abbreviated-fields-in-odbc/2791 "2022-02-22T18:20:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![stathis](https://avatars.discourse-cdn.com/v4/letter/s/e79b87/32.png) [@stathis](https://the.fmsoup.org/u/stathis)\
**Post date:** [February 22, 2022, 6:20pm UTC](https://the.fmsoup.org/t/underscore-abbreviated-fields-in-odbc/2791/1 "2022-02-22T18:20:07Z")

</div>

Hello soup community,

Does anyone have any experience with underscore abbreviated fields (e.g. \_ID).

It this going to be an issue while accessing data using SQL and ODBC ? How does the field need to be escaped in the external system ?

---

<div class="post-metadata">

**Author:** ![planteg](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/planteg/32/627_2.png) [@planteg](https://the.fmsoup.org/u/planteg)\
**Post date:** [February 22, 2022, 6:46pm UTC](https://the.fmsoup.org/t/underscore-abbreviated-fields-in-odbc/2791/2 "2022-02-22T18:46:13Z")

</div>

Hi,

you need to quote the table or fields names when they contain characters not allowed. For example you would use "\_IDxxx".

---

<div class="post-metadata">

**Author:** ![stathis](https://avatars.discourse-cdn.com/v4/letter/s/e79b87/32.png) [@stathis](https://the.fmsoup.org/u/stathis)\
**Post date:** [February 22, 2022, 7:04pm UTC](https://the.fmsoup.org/t/underscore-abbreviated-fields-in-odbc/2791/3 "2022-02-22T19:04:21Z")

</div>

Hi @planteg

Great, that’s what I suggested as well. Thank you for contributing.

Best