What is SUBSTR function?

What is SUBSTR function?

Rating:

The SUBSTR function returns a specific portion of a character string.

Syntax:

SUBSTR (<str>, <m>[, <n>])

where,

str is a character string.

m and n are integers.

The SUBSTR function returns a portion of str, which is n characters long, starting from position m. If m is positive, the position is counted from the beginning of the string. If m is negative, the position is counted backwards from the end of the string. If m is 0, it is treated as 1. If n is omitted, the function returns all the characters to the end of the string. The function returns NULL if n is 0 or negative.

Rating: