This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com
- 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 v20 R8
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
PAGE CONTENTS
HISTORY
ARTICLE USAGE
4D SQL Reference ( 4D v20 R8)
© 1985-2025 4D SAS / 4D, Inc. All rights reserved.