Select All Instances of Substring in a String

I have a varchar(max) column that holds a JSON request string. I need a SQL statement for a report that will select all of the instances of that substring. More specifically I need to grab the LoanId Value from that substring entry pulling a result set that contains a row for each LoanId. Any help would be greatly appreciated. A considerably abbreviated JSON string containing the stuff I'm looking for. [ {"loanId":"1111111111","someotherValue":7}, {"loanId":"2222222222","someotherValue":4}, {"loanId":"3333333333","someotherValue":5}, ]