Where does SQL's index start?

Question

Accepted Answer

SUBSTRING(string, start, length) extracts a substring. The start position is 1-indexed in SQL (not 0-indexed like most programming languages). Starting at position 1 and taking 5 characters gives 'Hello'. PostgreSQL also accepts SUBSTRING('Hello World' FROM 1 FOR 5) - both forms are valid.