Previous Topic

Next Topic

Book Contents

Book Index

General Information

The SUBSTR function extracts the number of characters in its second argument (len) from the data string in its third argument (strng) beginning with the character position in its first argument (pos). SUBSTR works on data strings only.

The first position in the string is position 1. Use the LENGTH function to determine the last position in the string.

Parent Topic

SUBSTR: Functions