The starts with
keyword checks if a text starts with another text.
This function is SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a Yes/No value
This check is not case-sensitive and ignores diacritics (accents).
A keyword to indicate a new line character (i.e. "\n" or ).
When concatenating strings, you can use the newline
keyword to separate the parts into lines. This only works when using standard texts (not rich texts) and display as text (not display as HTML). In the Rich Text / DIsplay HTML situation, you need to use the html-elements <p></p>
, <div></div>
or plainly <br/>
to put texts in different lines.
This function is SQL compatible. For more information about SQL compatibility, see our documentation.
The Contains
Keyword is a special one: it can be used on Texts, on Concept Sets and on Lists.
Check the main page for Contains.
The ends with
keyword checks if a text ends with another text.
This function is SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a Yes/No value
This check is not case-sensitive and ignores diacritics (accents).