> 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 | [email protected] 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" <[email protected]> wrote on 2013-05-07 10:13:44: > From: "Prather, Wanda" <[email protected]> > To: [email protected], > Date: 2013-05-07 10:20 > Subject: Re: select question on backups table > Sent by: "ADSM: Dist Stor Manager" <[email protected]> > > 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:[email protected]] On > Behalf Of Lee, Gary > Sent: Tuesday, May 07, 2013 9:03 AM > To: [email protected] > 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? >
