Doorgaan naar de website
OCLC Support

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
Applies to
  • ILLiad

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)


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)


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

Page ID