title: Wildcard or "LIKE" search in azure cosmos db with Gremlin Graph API
body: <p>I'm trying to search for vertices in a kind of wildcard search. In SQL it would be: "where name like '%abc%'". 
  Neither Gremlin graph traversal nor SQL-queries support it.</p>
  
  <p>The use case is to filter a 1:n dependency, e.g. "Show me all my customers whose name contains 'Sam'". This is pretty basic and easy with SQL. It is not an overall full text search but simply a filter in this specific 1:n releationship.</p>
  
  <p>Following SQL works:</p>
  
  <pre><code>SELECT * FROM g 
    where (g.label = "person" and g.name[0]._value = 'Sam')
  </code></pre>
  
  <p>which is equivalent to:</p>
  
  <pre><code>g.V().hasLabel("person").has("name", "Sam")
  </code></pre>
  
  <p>Following SQL does not work ("Syntax error, incorrect syntax near 'like'):</p>
  
  <pre><code>SELECT * FROM g 
    where (g.label = "person" and g.name[0]._value like 'Sam')
  </code></pre>
  
  <p>Trying to use a lambda in a Gremlin "filter" step results in an error, too. </p>
  
  <p>Is it a good idea to write a UDF oder Stored Procedure for this kind of search? How is indexing handled in that case? Are there any alternatives? </p>
  
  <p>Thanks a lot</p>