Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Escape Characters in Dynamic Queries in HANA


Hi All,

We are using Dynamic Queries in our Stored procedure and sometimes we need to use string literals (e.g. 'abc' or "YEAR_MONTH"||'01') in the query. Can anyone share the escape character which we need to use for single quote(') or for concatenation symbol (||)? I know I can first initialize a variable and use that variable in the query, but it will be nice to know, what should be the escape character if I need to hard code these literals in the query.

Regards,

Piyush

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question