firebird 40 language referencetakes two DECFLOAT arguments and returns the first argument scaled using the second value as a pattern TOTALORDER performs an exact comparison on two DECFLOAT values Detailed descriptions are available ESQL Syntax[NOT] LIKE <pattern> [ESCAPE ] ::= character-type expression <pattern> ::= search pattern ::= escape character character The LIKE predicate compares the character-type expression with the pattern defined in the second expression. Case- or accent-sensitivity for the comparison is determined by the collation that is 0 码力 | 778 页 | 3.43 MB | 1 年前3- Firebird 2.5 Language ReferenceESQL Syntax
[NOT] LIKE <pattern> [ESCAPE ] ::= character-type expression <pattern> ::= search pattern ::= escape character character The LIKE predicate compares the character-type expression with the pattern defined in the second expression. Case- or accent-sensitivity for the comparison is determined by the collation that is either operand, if required. Wildcards Two wildcard symbols are available for use in the search pattern: • the percentage symbol (%) will match any sequence of zero or more characters in the tested value 0 码力 | 521 页 | 2.30 MB | 1 年前3 - firebird language reference 30 rus1992' AND CURRENT_DATE LIKE Доступно в: DSQL, PSQL, ESQL. Синтаксис:
[NOT] LIKE <pattern> [ESCAPE ] Таблица 3.6. Параметры предиката LIKE Параметр Описание match value Выражение символьного типа. pattern Шаблон поиска. escape character Символ экранирования. Предикат LIKE сравнивает выражение символьного типа также: LIKE. SIMILAR TO Доступно в: DSQL, PSQL. Синтаксис: [NOT] SIMILAR TO <pattern> [ESCAPE ] Таблица 0 码力 | 719 页 | 3.98 MB | 1 年前3 - firebird 30 sprachreferenz
[NOT] LIKE <pattern> [ESCAPE ] Chapter 4. Allgemeine Sprachelemente 74 ::= character-type expression <pattern> ::= search pattern Chapter 4. Allgemeine Sprachelemente 77 Syntax string-expression [NOT] SIMILAR TO <pattern> [ESCAPE ] <pattern> ::= an SQL regular expression ::= a single character SIMILAR eine Zeichenkette anhand eines Regulären Ausdruck-Musters in SQL (engl. SQL Regular Expression Pattern). Anders als in einigen anderen Sprachen muss das Muster mit der gesamten Zeichenkette übereinstimmen 0 码力 | 701 页 | 3.12 MB | 1 年前3 - Firebird 2.5 LangRef Update RussianBoolean (логический) Синтаксис SIMILAR TO: string-expression [NOT] SIMILAR TO <pattern> [ESCAPE
] <pattern> ::= регулярное выражения SQL ::= одиночный символ Синтаксис регулярных 0 码力 | 364 页 | 1.45 MB | 1 年前3 - Firebird Null Guide: NULL behaviour and pitfalls in Firebird SQLBETWEEN • [NOT] STARTING WITH • [NOT] LIKE • [NOT] CONTAINING The explanations all follow the same pattern: if A is unknown, you can’t tell if it’s greater than B; if string S1 is unknown, you can’t tell0 码力 | 69 页 | 479.63 KB | 1 年前3
共 6 条
- 1