substring

Use this function to extract a substring from a string starting at, and ending with, a specified position.

Note: This function is only supported by the CDC Replication Engine for Event Server.
Syntax:
substring(value, beginIndex, [length])
Input Parameters:
value represents an input value: an expression, a literal, or a function.
beginIndex represents the beginning position, zero-based.
length represents the end position, zero based. If omitted, the substring runs to the end of the input string.
Return Value:
String
Example:
<sxt:element name=Area_Code value=substring(Phone, 0, 3)/>