Question 243 Views Jav Shamsuddin (JavS9029) StepChange Debt Charity StepChange Debt Charity GB View Profile Send Message JavS9029 Member since 2017 5 posts StepChange Debt Charity Posted: February 21, 2020 Last activity: February 21, 2020 Posted: 21 Feb 2020 5:37 EST Last activity: 21 Feb 2020 5:49 EST Closed Query runner - how to escape characters Report we are using a postgres back end on 7.3 , I have a sample query used in query runner which I can't get to work - select pxTimeCreated, pyMessageKey from pegadata.hst_sometable_work and pyMessageKey LIKE '[ABC%' the error i get is: ** Unclosed character class near index 6 '[FCC%' ^ I have tried using the character wild card i.e. and pyMessageKey LIKE '_ABC%' - but this returns no results. The following works but can't use this due to performance reasons and pyMessageKey LIKE '%ABC%' so how do I escape the character '[' in a sql query execute in the query runner ?? (This is part of a query to assist in trouble shooting - so want to run the query via query runner - not a report of any kind ) Pega Platform 7.3.1 Dev/Designer Studio Financial Services System Architect Like (0) Share Share this page Facebook Twitter LinkedIn Email Copy link Copying... Copied! Moderation Team has archived post, learn more This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.