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 searchedpattern
- expression for string to be locatedfrom
- expression for position at which to start search
- Return:
- expression corresponding to position
- Since:
- JPA 2.0