一个简单sql问题

[huyidehyd]

一字段为字符型a,其中一值为"abc",我想取小于和大于该值的各5个值（最接近），如何取？

[txlicenhe]

Select top 5 * from 表 where 字段<'abc' order by 字段 desc

Select top 5 * from 表 where 字段>'abc'

[pengdali]

select top 5 * from xx where a<>'abc' order by abs(cast(a as varbinary)-cast(cast('abc' as varbinary) as int))

[wzh1215]

select top 5 from table1 where a<'abc' order by a desc
union all
select top 5 from table1 where a>'abc' order by a

[huyidehyd]

谢谢，结贴！