Many Thanks Jeff / Eirikur for your replys.

Eirikur that works perfectly.

Thanks for all your help guys that has been paining me for a while.

Thanks Eirikur.

I have got it working with the following script.

create table #temp (Value varchar(500), Number int)

insert into #temp

(Value, Number)

select Source, (select charindex('\', reverse(Source))) from Table

select * from #temp

select distinct(left(Value, LEN(Value)-...