5 Replies Latest reply on Aug 20, 2014 5:44 AM by philmodjunk

    ExecuteSQL and field values containing special characters

    BenOtto

      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