ZipCode Table - City Field CAPS?

[hokiejill]

What is the best way to accomplish the following?

I would like the City field in the ZipCode table changed to all UPPER CASE. Currently, it’s upper/lower.

For example, Galax to GALAX.

[Johnny5]

Good day,

There is currently no method within the software to change the cities to all caps. I will consult development on this one.

JD

[timbre4]

In the meantime, you might consider changing your most popular zip codes to be CAPS using the Zip Code Mapping option under Standard Tables:

zip.png (18.09 KiB) Viewed 4117 times

[hokiejill]

I've taken care of the most common cities.

Is there a way to run SQL scripts on this database to make mass changes?

[sbebenelli]

What is the best way to accomplish the following?

I would like the City field in the ZipCode table changed to all UPPER CASE. Currently, it’s upper/lower.

For example, Galax to GALAX.

What's the reason for wanting this?

[hokiejill]

The reason is standardization. We have all name and address in all caps for all of our databases and software systems (we use other software besides Manager Plus).

[sbebenelli]

The reason is standardization. We have all name and address in all caps for all of our databases and software systems (we use other software besides Manager Plus).

Gotcha

[Johnny5]

I've taken care of the most common cities.

Is there a way to run SQL scripts on this database to make mass changes?

Yes there is - you would also want to update the customer address table to UPPERCASE.:
For the geeks out there the command are:

sqlcmd /E /S .\SHOPSTREAM -Q "UPDATE ShopMgt.SM.ZipCode SET [City] = UPPER(City)"
sqlcmd /E /S .\SHOPSTREAM -Q "UPDATE ShopMgt.SM.Addresses SET [City] = UPPER(City)"

Here is a link to a batch file that runs the commands for you, you have to run this on the host. No need to exit Manager. http://m1faqs.com/fix/SE/changetocaps.bat

JD