Title: SQL Tips and Tricks  
Author: Debra Howell Mar 22, 2022
Last Changed by: Sharon Helen Markus Mar 11, 2026
Tiny Link: (useful for email) https://dev.confluence.cornell.edu/x/GnWZGQ
Export As: Word · PDF  
Hierarchy
Parent Page
    Page: Getting Help
Children (29)
    Page: Capturing diacritics in exporting data
    Page: Getting Data that is Null when it is not stored as Null
    Page: Parsing out call numbers
    Page: Specifying Ranges
    Page: Optimizing Queries
    Page: MARC Query Samples
    Page: Working with Subject Headings
    Page: Multiple Fiscal Years - DRAFT
    Page: Querying array elements from a table's data blob (useful for non-MetaDB data)
    Page: Using the "Similar to" operator to find a list of values in a given field
Labels
There are no labels assigned to this page.
Recent Changes
Time Editor  
Mar 11, 2026 08:54 Sharon Helen Markus View Changes
Mar 11, 2026 08:53 Sharon Helen Markus View Changes
Nov 24, 2025 07:37 Sharon Helen Markus View Changes
Nov 21, 2025 14:49 Sharon Helen Markus View Changes
Nov 20, 2025 19:30 Joanne Elisa Leary  
Outgoing Links
External Links (30)
    https://confluence.cornell.edu/display/folioreporting/Addin…
    https://confluence.cornell.edu/display/folioreporting/Optim…
    https://confluence.cornell.edu/spaces/folioreporting/pages/…
    https://confluence.cornell.edu/display/folioreporting/MARC+…
    https://confluence.cornell.edu/display/folioreporting/Multi…
    https://confluence.cornell.edu/display/folioreporting/Using…
    https://confluence.cornell.edu/display/folioreporting/Captu…
    https://confluence.cornell.edu/display/folioreporting/Getti…
    https://confluence.cornell.edu/display/folioreporting/Worki…
    https://confluence.cornell.edu/display/folioreporting/Parsi…
    https://confluence.cornell.edu/display/folioreporting/Parsi…
    https://confluence.cornell.edu/display/folioreporting/Find+…
    https://confluence.cornell.edu/display/folioreporting/Speci…
    https://confluence.cornell.edu/pages/viewpage.action?pageId…
    https://confluence.cornell.edu/spaces/folioreporting/pages/…
    https://confluence.cornell.edu/pages/viewpage.action?pageId…
    https://confluence.cornell.edu/display/folioreporting/Worki…
    https://confluence.cornell.edu/display/folioreporting/Aggre…
    https://confluence.cornell.edu/display/folioreporting/Using…
    https://confluence.cornell.edu/display/folioreporting/Find+…
    https://confluence.cornell.edu/pages/viewpage.action?pageId…
    https://confluence.cornell.edu/display/folioreporting/Find+…
    https://confluence.cornell.edu/display/folioreporting/Conve…
    https://confluence.cornell.edu/display/folioreporting/Best+…
    https://confluence.cornell.edu/display/folioreporting/Setti…
    https://confluence.cornell.edu/display/folioreporting/Impor…
    https://confluence.cornell.edu/display/folioreporting/Show+…
    https://confluence.cornell.edu/display/folioreporting/Patte…
    https://confluence.cornell.edu/display/folioreporting/Conve…
    https://confluence.cornell.edu/spaces/folioreporting/pages/…
FOLIO Reporting (2)     Page: Getting Accurate MARC Record Counts in Metadb
    Page: Using the VTEST Voyager Historical Data Snapshot