Running the T-SQL you gave, I got 2 columns entitled ST and SR_RID
under ST there seems to be a mix of cities combined with the standard 2 letter postal abbrev for states , i.e. FL, GE MN, ETC...
Some of the records even returned Addresses under the ST Column, in addition to some having the City, as opposed to state info.
If somehow how I imported this wrong and the data was placed in the the wrong columns in some fields, I could understand, but doing SELECT *, I can view all the records and the ST Column shows only the 2 Ltr Postal Abbrevs. So ????
I apologize, I did not understand what you meant by my 'ddl'.