How do I put two Substring statements together into one?

[JanetH]

I have two substring queries that both work on their own but I can't seem to get the syntax right when I try and put them together into one query.
The first one is to remove the extension from a string
SUBSTRING(URI, 1, CHARINDEX('.',(URI)))

The second one is to return only the title of the page in a web address
REVERSE(SUBSTRING(REVERSE(URI), 1, CHARINDEX('/',REVERSE(URI))))

Whenever I try to put them together I get a syntax error or I get two seperate results, one without the extension and one containing just the title.
Thanks for your help.

 

[Andel]

What's is the value of your URI? And what would you like the output to be?
Andel
andelbarroga@hotmail.com

http://andyb.8m.com

 

[JanetH]

URI is the coloumn that I want to select so the value for it always changes depending on the record. An example of a record would be /wep/employee/Benefits.htm. What I would like to end up with is just Benefits.
With the first substring I gave above I would get
/wep/employee/Benefits.
The second would return:
Benefits.htm
So somehow I need to put the two together to just return Benefits.

 

[BobWard]

This works, i've replace @URI with your @URI. the text below will run in sqlserver

declare @URI as varchar(255)
select @URI = '/wep/employee/Benefwwits.htm'

select
substring(REVERSE(SUBSTRING(REVERSE(@URI), 1, CHARINDEX('/',REVERSE(@URI))-1)),1, charindex('.',REVERSE(SUBSTRING(REVERSE(@URI), 1, CHARINDEX('/',REVERSE(@URI))-1)))-1)

 

[Andel]

If you only want to return "benefits", you can do just one select statement.

select reverse(substring(reverse(@url), charindex('.', reverse(@url)) + 1, charindex('/',reverse(@url)) - charindex('.', reverse(@url)) - 1))



Andel
andelbarroga@hotmail.com

http://andyb.8m.com

 

[Andel]

Oppsss BobWard... we must have done that at the same time.
Andel
andelbarroga@hotmail.com

http://andyb.8m.com

 

[JanetH]

Thank you both so much. It works like a dream!!!