To get other subdirectories, you'll need to add the wildcard designator % (without a wildcard, "like" is the same as "=")
upper(hl_NAME) like '%\BIOMECHANICS\DICKIN\FATIGUE STUDY\FATIGUE STUDY%' -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary Sent: Tuesday, May 07, 2013 9:03 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] select question on backups table Tsm server 5.5.4. Windows client 6.3.0 Will the following select show me all backups at and below the designated subdirectory? select * from backups where node_name='CASTSTORAGE' AND - upper(hl_NAME) like '\BIOMECHANICS\DICKIN\FATIGUE STUDY\FATIGUE STUDY' If not, where have I gone wrong?