The exception to this rule is titles for songs or other shorter works in other languages that have an elided article.
Example: The safest way to search for Nadia Boulanger's song "Lechange" is to type in boulanger and l'echange. This is because this song may only appear in a contents note with its article intact.
For titles by non-English-speaking composers, search under:
Type this: handel AND "water music"
To retrieve this: Water Music by G. F. Handel
Type this: debussy AND mer
To retrieve this: La Mer by Claude Debussy
Type this: Stravinsky AND "soldat"
To retrieve this: l'histoire du soldat by Igor Stravinsky
Searching for generic titles in Library Search is sometimes a case of trial and error. The following tips may help:
Type this: Beethoven AND eroica and 3
To retrieve this: Beethoven's Eroica Symphony
Type this: Vivaldi AND oboe AND concerto
To retrieve this: Vivaldi's Oboe Concerto, RV 461 in A minor
Type this: Schubert AND trios AND 898
To retrieve this: Schubert's Piano Trio in B-flat