AnsweredAssumed Answered

ExecuteSQL and field values containing special characters

Question asked by BenOtto on Jul 8, 2014
Latest reply on Aug 20, 2014 by philmodjunk

Title

ExecuteSQL and field values containing special characters

Post

     Here is one of my SQL queries:

     ExecuteSQL ("SELECT COUNT (DISTINCT pname) FROM table1", "", "")

     The query works fine as long as the values in field pname don't have any special characters such as "-". Can I dynamically mask such characters or solve the problem somehow?

      

     cheers

     Ben

Outcomes