when SUBSTR returns NULL?

SUBSTR will always return NULL if number of characters to retrieve was specified as negative

 

SUBSTR will also return NULL if number of characters to retrieve was specified as zero

Leave a comment

Your email address will not be published. Required fields are marked *