SQL Query: How to Use LOCATE and Substring Correctly

Here are SQL queries to use the SUBSTRING function along with LOCATE function. LOCATE gives position, and SUBSTRING uses that for the start position.