SQL Syntax to pull part of String Field back..? (CharIndex..?)
Posted on 2013-05-23
My data field looks like this:
"Adventist Health System - Winter Park, FL"
This is a single String/Text Field and is consistent with the " - " and the ", " between the HospitalName and CityName, and the CityName and StateCode. All entries in this field follow this same format: HospitalName " - " CityName ", " StateCode
I have a requirement to pull ONLY the CITYNAME from the above string field.
So that would be I need to pull the TEXT between the " - " and the ", "
I need the function and syntax to use....THANKS