JPA Method
in javax.persistence.criteria.CriteriaBuilder

Expression<Integer> locate(
  Expression<String> x, 
  Expression<String> pattern, 
  Expression<Integer> from
)


Create expression to locate the position of one string within another, returning position of first character if found. The first position in a string is denoted by 1. If the string to be located is not found, 0 is returned.
Parameters:
x - expression for string to be searched
pattern - expression for string to be located
from - expression for position at which to start search
Return:
expression corresponding to position
Since:
JPA 2.0