Substance use literature covers a wide area. You might find books in all these call number ranges, so it will be easier to use OneSearch first (box below)
Government Publications - Most online, use catalog.
Psychology - BF
Sociology - HM, HN, HV
Public Health - RA
Medical/Pharmacology - RM, RS
Criminal Justice - K, KF
SDSU has theses and dissertations in print and online. The best option to find public health theses is to search the catalog.