Sometimes you may need to do something with your librarys' data that no library system can predict. The SQL Command Access window will allow you to run your own programs within LiBRARYSOFT™. You do not need to know SQL language, just email or call us with a request and we can email you SQL code that you can copy and paste into the command window. It's like have a hidden super power.

Some examples of how you could use SQL code include:

• Increasing the barcode numbers of all items by a certain number.
• Moving all the values within one field, say Alternate Call Number, into the Call number field.