Display the first word after the street number in a supplier's street address. For example, for the supplier "1 Pine Apple St.", the first work after the street number is "Pine". Show the suppliers street address and the first word after the street number. I have an example with using a different layout in my book but this is confusing to me

Street Address	First word after street address
1 Pine Apple St	Pine
123 International Blvd	International
33 Beijin Square	Beijin
1 Electronics Road	Electronics
12 Camera St	Camera

Excample SQL

Select CustomerName, Substring(CustomerName, Charindex('e', CustomerName)+1 Charindex('e', CustomerName, charindex('e', CustomerName)+1) -charindex('e', CustomerName)-1 ) AS "Characters between the two e"

From Sales.Customers

Where CustomerName LIKE '%e%e%';

I am not sure what to put in place of the 'e' for the Suppler address as shown in the above table. I just need a push here.