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 AT VM.MARIST DOT EDU] On Behalf Of 
Lee, Gary
Sent: Tuesday, May 07, 2013 9:03 AM
To: ADSM-L AT VM.MARIST DOT 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?