4D v13.4
like_predicate
- 4D SQL Reference
-
- Syntax rules
-
- Syntax rules
- 4d_function_call
- 4d_language_reference
- all_or_any_predicate
- arithmetic_expression
- between_predicate
- case_expression
- column_definition
- column_reference
- command_parameter
- comparison_predicate
- exists_predicate
- foreign_key_definition
- function_call
- in_predicate
- is_null_predicate
- like_predicate
- literal
- predicate
- primary_key_definition
- search_condition
- select_item
- sort_list
- sql_data_type_name
- sql_name
- sql_string
- subquery
- table_constraint
- table_reference
- odbc_constant
like_predicate
|
arithmetic_expression [NOT] LIKE arithmetic_expression [ESCAPE sql_string] |
||
A like_predicate is used to retrieve data matching the arithmetic_expression passed after the LIKE keyword. You can also pass the NOT keyword to search for data differing from this expression. The ESCAPE keyword can be used to prevent the character passed in sql_string from being interpreted as a wildcard. It is usually used when you want to search for the '%' or '_' characters.
This example selects the suppliers whose name contains "bob":
SELECT * FROM suppliers
WHERE supplier_name LIKE '%bob%';Selects suppliers whose name does not begin with the letter T:
SELECT * FROM suppliers
WHERE supplier_name NOT LIKE 'T%';Selects suppliers whose name begins with "Sm" and ends with "th":
SELECT * FROM suppliers
WHERE supplier_name LIKE 'Sm_th'
Product: 4D
Theme: Syntax rules
arithmetic_expression
predicate
