> upper(hl_NAME) like '%\BIOMECHANICS\DICKIN\FATIGUE STUDY\FATIGUE STUDY%'

This is pretty close to what I also responded with. However, it will pick
up entries not only in '..\FATIGUE STUDY', but also in '..\FATIGUE STUDY -
PRELIMINARY' or '..\FATIGUE STUDY2', which might not be desirable.

This is probably closer to what Gary is looking for:

> upper(hl_NAME) like '%\BIOMECHANICS\DICKIN\FATIGUE STUDY\FATIGUE STUDY\%'

- Andy

____________________________________________________________________________

Andrew Raibeck | Tivoli Storage Manager Level 3 Technical Lead |
storman AT us.ibm DOT com

IBM Tivoli Storage Manager links:
Product support:
http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_Storage_Manager

Online documentation:
https://www.ibm.com/developerworks/mydeveloperworks/wikis/home/wiki/Tivoli
Documentation Central/page/Tivoli Storage Manager
Product Wiki:
https://www.ibm.com/developerworks/mydeveloperworks/wikis/home/wiki/Tivoli
+Storage+Manager/page/Home

"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu> wrote on 2013-05-07
10:13:44:

> From: "Prather, Wanda" <Wanda.Prather AT ICFI DOT COM>
> To: ADSM-L AT vm.marist DOT edu,
> Date: 2013-05-07 10:20
> Subject: Re: select question on backups table
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
>
> 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?
>