About trim

1-10 of 14Refresh
Manual
148

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
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
87

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
87

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
87

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
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
43

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
24

FROM clause (JPQL / Criteria API)

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

ObjectDB Object Database Features

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