如何取出一个字段中不满10位的数据?如
T1
字段1
1111111111
2222222222
3333333333
aaaaaaaaaa
bbbbbbbbbb
eeeeeeeee
ccccc
--------------------
结果
eeeeeeeee
ccccc
T1
字段1
1111111111
2222222222
3333333333
aaaaaaaaaa
bbbbbbbbbb
eeeeeeeee
ccccc
--------------------
结果
eeeeeeeee
ccccc
--> (让你望见影子的墙)生成测试数据,时间:2009-01-18
if not object_id('tb') is null
drop table tb
Go
Create table tb([字段1] nvarchar(10))
Insert tb
select N'1111111111' union all
select N'2222222222' union all
select N'3333333333' union all
select N'aaaaaaaaaa' union all
select N'bbbbbbbbbb' union all
select N'eeeeeeeee' union all
select N'ccccc'
Go
Select * from tb
where len(字段1)<10eeeeeeeee
ccccc
where len(字段1)<10
declare @t1 table (字段1 nvarchar(15))
insert into @t1 select '1111111111'
union all select '2222222222'
union all select '3333333333'
union all select 'aaaaaaaaaa'
union all select 'bbbbbbbbbb'
union all select 'eeeeeeeee'
union all select 'ccccc'
select * from @t1 where len(LTRIM(字段1))<10
eeeeeeeee
ccccc