I actually used a pipe on your suggestion even thought I knew there were no commas in the city names

Hell I better add more.

I just used part of the create statement to show the table structure - it was not the actual create statement.

The bulk insert adds in the...

Thanks