About trim

1-10 of 16Refresh
JPA Doc
89

trim(ts, t, x)

Method javax.persistence.criteria.CriteriaBuilder Expression trim(   Trimspec ts,   char t,   Expression x ) Create expression to trim character from a string. Parameters: ts - trim specification t - character to be trimmed x - expression for string to trim Returns: trim expression Since: JPA 2.0
JPA Doc
89

trim(ts, t, x)

Method javax.persistence.criteria.CriteriaBuilder Expression trim(   Trimspec ts,   Expression t,   Expression x ) Create expression to trim character from a string. Parameters: ts - trim specification t - expression for character to be trimmed x - expression for string to trim Returns: trim expression Since: JPA 2.0
JPA Doc
88

trim(t, x)

Method javax.persistence.criteria.CriteriaBuilder Expression trim(   char t,   Expression x ) Create expression to trim character from both ends of a string. Parameters: t - character to be trimmed x - expression for string to trim Returns: trim expression Since: JPA 2.0
JPA Doc
88

trim(t, x)

Method javax.persistence.criteria.CriteriaBuilder Expression trim(   Expression t,   Expression x ) Create expression to trim character from both ends of a string. Parameters: t - expression for character to be trimmed x - expression for string to trim Returns: trim expression Since: JPA 2.0
JPA Doc
88

trim(ts, x)

Method javax.persistence.criteria.CriteriaBuilder Expression trim(   Trimspec ts,   Expression x ) Create expression to trim blanks from a string. Parameters: ts - trim specification x - expression for string to trim Returns: trim expression Since: JPA 2.0
Manual
86

Strings in JPQL and Criteria Queries

to 'germany'. TRIM - Stripping Leading and Trailing Characters The TRIM([[LEADING|TRAILING|BOTH] [char ... space characters). For example: TRIM(' UK ') is evaluated to 'UK'. TRIM(LEADING FROM ' UK ') is evaluated to 'UK '. TRIM(TRAILING FROM ' UK ') is evaluated to ' UK'. TRIM(BOTH FROM ' UK ') is evaluated
JPA Doc
86

trim(x)

Method javax.persistence.criteria.CriteriaBuilder Expression trim(   Expression x ) Create expression to trim blanks from both ends of a string. Parameters: x - expression for string to trim Returns: trim expression Since: JPA 2.0
JPA Doc
39

javax.persistence.criteria.CriteriaBuilder

: character - expression Returns: Expression Since: JPA 2.0 Expression trim( Expression x) Create expression to trim blanks from both ends of a string. Create expression to trim blanks from both ends of a string. Parameters: x - expression for string to trim Returns: trim
Manual
21

FROM clause (JPQL / Criteria API)

, SUBSTRING, SUM, THEN,TRAILING, TRIM, TRUE, TYPE, UNKNOWN, UPDATE, UPPER, VALUE, WHEN, WHERE. JPQL
Result
21

ObjectDB Object Database Features [2018-01-27]

(LIKE, CONCAT, TRIM, SUBSTRING, ...). JPQL collection operators & functions (IS EMPTY, MEMBER OF, SIZE