Skip to main content
OCLC Support

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

Symptom
  • You want to know how to change to Uppercase for all the Lender Strings in the Lender Address table
Applies to
  • ILLiad
Resolution

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.

Page ID
24683