KQL - how to find specific string RRS feed

  • Question

  • I'm trying to write a KQL query that looks for a specific sub string in a string.

    For example, I have the string "Hot Creek" in a column.

    I'd like to be able to find this string by search for "ot", "t C" or "Cree".

    In T-SQL or FullTextQuerySQL I can find the above sub strings using LIKE. For example if I have a column named Title,

    Title LIKE '%ot%'

    Title LIKE '%t C%'

    Title LIKE '%Cree%'

    Is there a way to do this with KQL?

    Friday, November 30, 2012 6:09 PM


All replies