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'.

Thanks

Spatio