Using LIKE With Date String 1

[tekdudedude]

Hello,

How can I extend the below SQL so as it will return all string matches for 20080513 and greater. Greater in this case would mean values like: myfile_20080514.bus, myfile_20080515.bus etc.

SELECT fname FROM V$BACKUP_FILES WHERE fname LIKE '%20080513%.BUS';

Thanks,

TD

 

[PHV]

You may try this:

SELECT fname
FROM V$BACKUP_FILES
WHERE fname LIKE '%200_____.BUS'
AND SUBSTRING(fname FROM POSITION('.BUS' IN fname)-8 FOR 8)>='20080513'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[tekdudedude]

PHV,

Niceley done. Thanks for posting.

TD