How do I return only part of a string from a coloumn

[JanetH]

I have created a stored procedure that will retrieve the number of hits on each page of a website by month. The column in the database that contains the page title contains almost the full web address for each page minus the root ex. /sample/archive/archive1.htm. My second problem is that each page title is a different length and may have as many as three "/'s". I want to display only the last word in the address ex. archive1.htm. Is there any way to do this using SQL and not a report type application. The stored procedure emails the results to me. I'm using SQL Server 6.5

 

[foxdev]

You can use combinations of SUBSTRING, CHARINDEX, REVERSE, and RIGHT to pull out just the file name. We had another thread on this issue about a week and a half ago. Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org

 

[Andel]

Look for this tread, 183-60723, for example.
Andel
andelbarroga@hotmail.com

http://andyb.8m.com