求一条简单的sql语句 拜托了

[luyuanshangao]

取出表A中Id为两位数的记录

取出表A中Id为四位数且前两位跟传进来的参数一样的记录

[黄_瓜]

1、
select * from a where len(id)=2

[yananguo_1985]

select * from A where len(id)=2

select * from A where len(id)=4 and left(id,2)=参数

[luyuanshangao]

谢谢两位 等下结贴

[黄_瓜]

2、
select * from a where len(id)=2 and id like'11%'

[qiqi860819]

select * from A where len(id)=2
select * from A where len(id)=4 and left(id,2)=参数

[--小F--]

select  * from tb where len(id)=2

[黄_瓜]

select * from a where len(id)=2 and left(id,2)=@canshu

[--小F--]

select * from A where len(id)=4 and left(id,2)=参数

[luyuanshangao]

select * from A where len(id)=2
select * from A where len(id)=4 and left(id,2)=参数

拜托各位再帮忙把上面的两条sql写成个存储过程

参数 是ID
我的ID是01，0101，010101这样的分3级
如果传进来的ID参数ID=01 就找到0101 如果是0101 就找到010101

拜托了