code name
1 111 11
12 12
112 112
121 121
123 123
131 131
2 2
21 21
22 22
211 211
215 215
224 224
...
如何查出112-211的数据?
1 111 11
12 12
112 112
121 121
123 123
131 131
2 2
21 21
22 22
211 211
215 215
224 224
...
如何查出112-211的数据?
select * from tb Where cast(Code AS CHAR(3)BETWEEN '112' And '211'
select * from tb Where cast(Code AS CHAR(3)) BETWEEN '112' And '211'