| D toc |
|---|
| Excerpt |
|---|
Returns |
Source values can be string literals, column references, or expressions that evaluate to strings.
| D s lang vs sql |
|---|
| D s | ||
|---|---|---|
|
String literal reference example:
| D lang syntax | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
stringlessthanequal('a','a') |
Output: Returns true since both values are the same.
String literal reference example:
| D lang syntax | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
stringlessthanequal('a','b') |
Output: Returns true since a evaluates to be less than b.
String literal reference example:
| D lang syntax | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
stringlessthanequal('abc','x') |
Output: Returns true since the first letter of the first string is less than the first letter of the second string.
Column reference example:
| D lang syntax | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
stringlessthanequal(string1,string2) |
Output: Returns the evaluation of string1 column values being greater than string2 column values.
D s snippet Collation Rules style h2
Include Page String Collation Rules String Collation Rules
| D s | ||
|---|---|---|
|
| D lang syntax | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
stringlessthanequal(string_ref1,string_ref2 [,ignore_case]) |
| Argument | Required? | Data Type | Description |
|---|---|---|---|
| string_ref1 | Y | string | Name of first column or first string literal to apply to the function |
| string_ref2 | Y | string | Name of second column or second string literal to apply to the function |
| ignore_case | N | string | When true, matching is case-insensitive. Default is false. |
| D s lang notes |
|---|
string_ref1, string_ref2
String literal, column reference, or expression whose elements you want to compare based on this function.
D s snippet usage
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | String literal, column reference, or expression evaluating to a string | myString1, myString2 |
ignore_case
When true, matches are case-insensitive. Default is false.
| Info |
|---|
NOTE: This argument is not required. By default, matches are case-sensitive. |
| Required? | Data Type | Example Value |
|---|---|---|
| No | String literal evaluating to a Boolean | 'true' |
| D s | ||
|---|---|---|
|
Example - Simple string comparisons
Include Page EXAMPLE - String Comparison Functions EXAMPLE - String Comparison Functions
D s also label string
