4D v16
sql_string
- 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
4D v16
sql_string
sql_string
|
sql_string |
||
An sql_string contains a single-quoted string. Single quote characters that are located inside a string are doubled and strings that are already single-quoted are double-quoted before being placed within another pair of single quotes.
Examples:
| String to pass | sql_string |
| my string | 'my string' |
| string with ' inside it | 'string with ' ' inside it' |
| 'string already in quotes' | ' ' 'string already in quotes' ' ' |
See also
PROPERTIES
Product: 4D
Theme: Syntax rules
HISTORY
ARTICLE USAGE
4D SQL Reference ( 4D v16)
© 1985-2018 4D SAS / 4D, Inc. All rights reserved.