My [Locations] field is a character field that contains <addresses> separated by commas
ie: (1 University Avenue, 3 Maple Street, 575 Commonwealth Avenue,,,,,,,)
I want to select the <address> between the 2nd and the 3rd comma ......575 Commonwealth Avenue
Can someone please help me with the syntax for writing this select statement.
I've tried some due diligence, but am having problems.
In another scenario, I'm also going to need to update the address by specifying its location in the textstring.
Thanks in advance for your help.
-Gary