I do not know if SQL Server has syntax like VB or not.
In VB you may use InStrRev() function to determine how many characters
from the beginning of the string to the last "\", then use the Right() function
to extract the string you need which has the length calculated by the Len()...
I am a newbee in SQL Server.
I know this task can be done easily with VB functions such as:
InStr(), Left(), Mid(), Right(), Replace(), Len() functions.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.