5 Replies Latest reply on Sep 24, 2014 5:45 PM by luggage

    Dynamic Query escape character


      I'm creating a dynamic query for a group based on the SNMP Location field which has its field delimiters as an underscore "_"


      Naturally in SQL this would be a single wildcard character but I really need this query to include that "_" to differentiate this from Location strings that do not confirm to this standard.


      I can't find record of the escape character defined and have tried the usual "\", quotes, etc.


      Is an escape character defined globally or can I define one? Am I just going to have to go and find a different delimiter and change this config across the board?