In ILLiad, how do I change my Lender Address table so the Lender strings are all Uppercase?

You want to know how to change to Uppercase for all the Lender Strings in the Lender Address table

It is best to run the SQL command to update the keys.

1. If you are on a single server, then you will want your SQL Administrator to use this query:

UPDATE LenderAddresses
SET Lenderstring = UPPER(Lenderstring)

go

2. If you are on a Shared server, and you want it done for all the sites, then you use this query:

UPDATE LenderAddressesALL
SET Lenderstring = UPPER(Lenderstring)

go

3. If you are hosted by OCLC, contact OCLC Support.

24683