# Invalid character specified for alias: tableName (columnName)

**URL:** <https://community.cdata.com/t/invalid-character-specified-for-alias-tablename-columnname/462>\
**Category:** Data Sources\
**Tags:** article, dynamics-crm, alias\
**Created:** [October 16, 2023, 9:24pm UTC](https://community.cdata.com/t/invalid-character-specified-for-alias-tablename-columnname/462 "2023-10-16T21:24:47Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Luçjano\_Capo](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/lu%C3%A7jano_capo/32/1638_2.png) [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\
**Post date:** [October 16, 2023, 9:24pm UTC](https://community.cdata.com/t/invalid-character-specified-for-alias-tablename-columnname/462/1 "2023-10-16T21:24:48Z")

</div>

The error message, “_Invalid character specified for alias: account (id). Only characters within the ranges [A-Z], [a-z] or [0-9] or \_ are allowed.&nbsp; The first character may only be in the ranges [A-Z], [a-z] or \__” is clear in its explanation. It indicates that this error occurs when a column name does not commence with a letter or underscore, or it includes special characters.

To be able to surpass this issue, you will need to utilize the connection property called **QueryMethod** ([CData ODBC Driver for Microsoft Dynamics CRM - QueryMethod](https://cdn.cdata.com/help/RMJ/odbc/RSBDynamicsCRM_p_QueryMethod.htm)). This property is set to **FetchXML** by default, which treats the query as XML, therefore the special characters are mistakenly taken as functions. When changing it to **QueryExpression** which is object-oriented, the column name is treated as a string and resolves any issues with special characters.

 ![09e1f3b8-5958-42ce-8be2-8014dddb6477.png](https://us1.discourse-cdn.com/cdata/original/1X/e41ea34e94f2d861d3fc9ff9ad1e24a39bd1aec1.png)

Please reach out to [support@cdata.com](mailto:support@cdata.com) if this does not resolve the problem for you.
