How can we retrieve a specific character from a string using SQL?

In SQL, you can use the SUBSTRING function to extract a specific character from a string. The SUBSTRING function requires the string, starting position, and length as parameters. Here is an example:

SELECT SUBSTRING('Hello', 3, 1) AS Result;

This query will return the character ‘l’ starting at position 3 in the string ‘Hello’.