1 Reply Latest reply on Apr 17, 2008 5:59 AM by bjg-Oracle

    How to make case insensitive string match in SPARQL query?

    617912
      I need a way to make a case insensitive way of string matching in SPARQL.How can it be done? Also, is there any manual for the REGEXP_like() function??


      Thanks,
      Rajesh.
        • 1. Re: How to make case insensitive string match in SPARQL query?
          bjg-Oracle
          Hi Rajesh,

          There is a form of the REGEXP_like function that takes a third parameter as string.
          If it is 'i' then the match is done case insensitively.

          Syntax:
          regexp_like (string, pattern);
          regexp_like (string, pattern, parameters);

          parameters can be a combination of

          i: to match case insensitively
          c: to match case sensitively
          n: to make the dot (.) match new lines as well
          m: to make ^ and $ match beginning and end of a line in a multiline string

          Thanks
          Bhaskar