ExecuteSQL and field values containing special characters
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?