小妹刚学SQL,很简单的一个语句,敬请大家指教..先谢过了.

[WOCAOSQL]

比如现在 用NO='123'查, 希望能查出NO='123' or '132' or'213' or'231' or'312' or'321'
恕我笨..

[tanxiangfeng]

select * from table
where NO in('123' , '132' ,'213' ,'231' ,'312' ,'321')

[xeqtr1982]

declare @t table(no varchar(10))
insert into @t select '123'
insert into @t select '132'
insert into @t select '213'
insert into @t select '123'

select * from @t where no like '%[1-3]%'
--这样？

[xeqtr1982]

select * from @t where patindex('%[1-3]%',no)>0

[marco08]

where NO in ('123', '132', '213', '231', '312', '321')
IN关键字相当于多个OR