ObjectDB Database Search

') is evaluated to 5 . LOCATE - locating substrings The LOCATE(str, substr [, start]) function searches for a substring in a string and returns the substring's starting position. For example: LOCATE ... ). Therefore, the position of the first character is 1 . A value of zero ( 0 ) is returned if the substring is not

substring (    Expression x ,    Expression from ) Create an expression for substring extraction. Extracts a substring starting at the specified position through to end of the string ... : expression corresponding to substring extraction. Since: Jakarta Persistence (JPA) 1.0

substring (    Expression x ,    int from ) Create an expression for substring extraction. Extracts a substring starting at the specified position through to end of the string. First ... corresponding to substring extraction. Since: Jakarta Persistence (JPA) 1.0

substring (    Expression x ,    Expression from ,    Expression len ) Create an expression for substring extraction. Extracts a substring of given length starting ... expression len - length expression Returns: expression corresponding to substring extraction. Since: Jakarta Persistence (JPA) 1.0

substring (    Expression x ,    int from ,    int len ) Create an expression for substring extraction. Extracts a substring of given length starting at the specified position ... : expression corresponding to substring extraction. Since: Jakarta Persistence (JPA) 1.0

substring of a string, Parameters: x - string expression len - length of the substring to return Returns: expression for the leftmost substring . Since: Jakarta Persistence (JPA) 1.0 Expression left ( Expression x , Expression len ) Create an expression for the leftmost substring of a string, Parameters: x

i want to select all entities whose name starts with a specific letter, i can use this query with a string parameter select f from Foo f where substring (f.name, 1, 1) = ?1 but when i use a char, the query does not return anything. i think it should also be possible to use char/Character types

, SET, SIZE, SOME, SQRT, SUBSTRING , SUM, THEN,TRAILING, TRIM, TRUE, TYPE, UNKNOWN, UPDATE, UPPER, VALUE

) String expressions ( like , length , locate , lower , upper , concat , substring , …) Date and time

replace (    Expression x ,    Expression substring ,    Expression replacement ) Create an expression replacing every occurrence of a substring within a string. Parameters: x - string expression replacement - the replacement string substring - the literal substring

replace (    Expression x ,    String substring ,    Expression replacement ) Create an expression replacing every occurrence of a substring within a string. Parameters: x - string expression replacement - the replacement string substring - the literal substring to replace

replace (    Expression x ,    Expression substring ,    String replacement ) Create an expression replacing every occurrence of a substring within a string. Parameters: x - string expression replacement - the replacement string substring - the literal substring to replace

substring of a string, Parameters: x - string expression len - length of the substring to return Returns: expression for the rightmost substring . Since: Jakarta Persistence (JPA) 1.0

(    Expression x ,    int len ) Create an expression for the leftmost substring of a string, Parameters: x - string expression len - length of the substring to return Returns: expression for the leftmost substring . Since: Jakarta Persistence (JPA) 1.0

substring of a string, Parameters: x - string expression len - length of the substring to return Returns: expression for the rightmost substring . Since: Jakarta Persistence (JPA) 1.0

substring of a string, Parameters: x - string expression len - length of the substring to return Returns: expression for the leftmost substring . Since: Jakarta Persistence (JPA) 1.0

a unique substring from the query plan XML, so specifying the index name should work. support Support ... ? If it is, then any unique substring from that query plan that doesn't depend on parameters should work

ParseException {         String dateOfBirthStr = personalNumber. substring (0