# Escape special characters in KCQL

**URL:** <https://ask.lenses.io/t/escape-special-characters-in-kcql/38>\
**Category:** Apache Kafka Connectors\
**Created:** [April 11, 2023, 2:48pm UTC](https://ask.lenses.io/t/escape-special-characters-in-kcql/38 "2023-04-11T14:48:59Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![andrewstevenson](https://dub1.discourse-cdn.com/flex017/user_avatar/ask.lenses.io/andrewstevenson/32/15_2.png) [@andrewstevenson](https://ask.lenses.io/u/andrewstevenson)\
**Post date:** [April 11, 2023, 2:48pm UTC](https://ask.lenses.io/t/escape-special-characters-in-kcql/38/1 "2023-04-11T14:48:59Z")

</div>

Escaping special character in KCQL is done by enclosing the statement in backticks _ **`** _

We need to enclose the whole path in backticks.

kcql=INSERT INTO myKafkaTopic SELECT \* FROM `/some/path/#`