the string to extract from
the position of the first character to extract
the length of thing to extract
SELECT SUBSTRING("Amaryllis", 4, 3)
SUBSTRINGfunction requires two arguments and can take a third. The first argument is the string to be found and it can be stated either as a string or as a column. The second argument is the placement in the string of the first character to be returned. The third (optional) argument is the number of characters to be returned. If the third argument is omitted, the query returns all of the string from the first returned character on.