3.2.51. SUBSTR(string,start[,[length][,padchar]]) Returns the substring of string that starts at start, and has the length length. Length defaults to the rest of the string. Start must be a positive whole, while length can be any non-negative whole number. It is not an error for start to be larger than the length of string. If length is specified and the sum of length and start minus 1 is greater that the length of string, then the result will be padded with padchars to the specified length. The default value for padchar is the <space> character. SUBSTR(‘Foo bar’, 3) –> ‘o bar’ SUBSTR(‘Foo bar’, 3, 3) –> ‘o b’ SUBSTR(‘Foo bar’, 4, 6) –> ‘ bar ‘ SUBSTR(‘Foo bar’, 4, 6, ‘*’) –> ‘ bar**’ SUBSTR(‘Foo bar’, 9, 4, ‘*’) –> ‘****’
PREV NEXT