Method: Substring to end
Function name: substring
Parameter list: (CHAR ColumnName,INT nFrom)
Return type: CHAR
What the method does: Extracts a specific substring from a source column string value: the substring starts at the indicated position in the source string and extends to the end of that string.
You specify two parameters:
-
Source column name
-
Position at which to begin the extraction.
The first character in the source string is position 1.