declare @vid varchar(100)
set @vid='001'
select count(*) from area where vid like @vid+'%' and len(vid)>len(@vid)

create table area (vid varchar(100)) 
insert into area values('001') 
insert into area values('002') 
insert into area values('003') 
insert into area values('004') 
insert into area values('005') 
insert into area values('006') 
insert into area values('001001') 
insert into area values('001002') 
insert into area values('001003') 
insert into area values('001004') 
insert into area values('002001') 
insert into area values('002002') 
declare @vid as varchar(100)

set @vid = '001'

select result = count(*) from area where vid like @vid + '%' and len(vid) <> len(@vid)

/*
result      
----------- 
4

（所影响的行数为 1 行）
*/

set @vid = '002'

select result = count(*) from area where vid like @vid + '%' and len(vid) <> len(@vid)

/*
result      
----------- 
2

（所影响的行数为 1 行）
*/

drop table area