Problem With Max Value Of Name In My Views Table.Any Help Please?

hi all

i am having problem in finding the max value of name in my views table

i have names stored in my table as view1,view2 etc, so what i wanted to do is i want to find the next max value of the name which obviously 3 so my new name will be view3

the problem is if some one already created a name as 'view of john' then i am running in to problem by using this statement



Code:

SELECT @viewcount=ISNULL(max(CAST(SUBSTRING(Name,5,len(Name)) AS Integer)),0)+1
FROM Views
WHERE Name LIKE 'View%'

SET @ViewName='View'+cast(@viewcount as varchar(8))




here is the sample data


Code:

create table Views(Name varchar(50))

insert into Views(Name)
values('View1')

insert into Views(Name)
values('View2')

insert into Views(Name)
values('View of John')




i hope any genius can guide me in solving the problem.

thanks in advance