i need to get a string between two characters from the end of the string. E.G:
DECLARE @st varchar(250)
SET @st = ‘http://www.somedomain.com/file/rch1231/’ the final resoukt should be: rch1231
thanks from advanced,
Thanks a lot for the solution. working great.