- ON clause
- Accepts the InputTable clause.
- TargetColumns
- Specifies the name of the input table columns to apply the string operator.
- StringOperation
- Specifies a string operator (str_operator) from the following table. If str_operator requires string, length, or start_index, specify that value with String, StringLength, or StartIndex.
str_operator Description CHARTOHEXINT Converts value to its hexadecimal representation. GETNCHARS Returns length characters from value. See Optional Syntax Elements for TD_StrApply (OperatingSide).
INITCAP Capitalizes first letter of value. STRINGCON Concatenates string to value. STRINGINDEX Returns index of first character of string in value. See Optional Syntax Elements for TD_StrApply (IsCaseSpecific).
STRINGLIKE Returns first string that matches specified pattern if one exists in value. See Optional Syntax Elements for TD_StrApply (EscapeString, IsCaseSpecific, IgnoreTrailingBlank).
STRINGPAD Pads value with string to length. See Optional Syntax Elements for TD_StrApply (OperatingSide).
STRINGREVERSE Reverses order of characters in value. STRINGTRIM If value contains string, trim string from value. See Optional Syntax Elements for TD_StrApply (OperatingSide)..
SUBSTRING Returns substring starting at start_index with length from value. TOLOWER Replaces uppercase letters in value with lowercase equivalents. TOUPPER Replaces lowercase letters in value with uppercase equivalents. TRIMSPACES Trims leading and trailing space characters from value. UNICODESTRING Converts LATIN value to UNICODE.