SQL - Find substring in char string

[Going to Cali]

Say i have a string

str = 'abcdefghij.......z',

Is there a function that, given a substring of str (such as 'abc') , would return all of a?

Sorry if it's a stupid question, I cannot find anything on google.

 

[Going to Cali]

Thanks a lot, very useful.