467,915 Members | 1,383 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

To print only the file name

Hi all,

when we write a query to know backup of database from system table it gives us the full path,i.e


But i want only the filename as output i.e "adba_databasename_tiemstamp.bkp"
is there any string function to it.
Nov 18 '08 #1
  • viewed: 1208
2 Replies
Expert 2GB
1. Reverse the string.

2. Get the position of the first "\".

3. Do a substring from the first position of the reversed string to the position of the first "\"..

Happy coding!

-- CK
Nov 18 '08 #2
Thanks for your help......
Dec 18 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

12 posts views Thread by Peter Lin | last post: by
5 posts views Thread by Brad Pears | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.