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

    Dynamic Query escape character

    luggage

      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?