Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 30 Dec 2014 @ 17:33:56 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Query to find Backup tables
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, December 30, 2014 10:13 -->

If you are on TD14.0 or later, REGEXP_SIMILAR can be used to match a string ending with underscore followed by digits.

Otherwise you can use POSITION and SUBSTRING to extract individual trailing characters, test if they are LIKE ANY ('0','1',...,'9') and verify the preceding underscore.



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023