求一个查询条件，请大侠指点一下！！！

[galaxy_1981]

表A:

ID SteelNum theDate Locker LOCK(BOOL) BWide BLong
1 s0001 2017-2-3 wang true 100 200
2 s0002 2017-2-9 wang true 200 500
3 s0003 2017-2-11 'null' false 500 600
4 s0006 2017-3-1 ' null' false 350 440
5 s0009 2017-3-9 zhao true 200 350
……

数据帅选：选择一个“时间区域”，将“LOCK为false” 以及 “LOCK为true并且Locker和当前用户名一致”的记录查询出来

我自己写的查询条件始终搞不定

 where (Lock = 0) OR (Lock = 1 AND Locker = 'wang')  and theDate >= '2017-2-5'

这样写的结果是全部数据都出来了


请大侠看看这个查询条件应该怎么写呢？

关注。。。。。。

[0与1之间]

把OR条件再括起来： where ((Lock = 0) OR (Lock = 1 AND Locker = 'wang')) and theDate >= '2017-2-5'

[二月十六]

字段类型可能有点不一样：

--测试数据
if not object_id(N'Tempdb..#T') is null
	drop table #T
Go
Create table #T([ID] int,[SteelNum] nvarchar(25),[theDate] Date,[Locker] nvarchar(24),[LOCK] nvarchar(25),[BWide] int,[BLong] int)
Insert #T
select 1,N's0001','2017-2-3',N'wang',N'true',100,200 union all
select 2,N's0002','2017-2-9',N'wang',N'true',200,500 union all
select 3,N's0003','2017-2-11',null,N'false',500,600 union all
select 4,N's0006','2017-3-1',null,N'false',350,440 union all
select 5,N's0009','2017-3-9',N'zhao',N'true',200,350
Go
--测试数据结束
SELECT  *
FROM    #T
WHERE   ( Lock = 'false' )
        OR ( Lock = 'true'
             AND Locker = 'wang'
           )
        AND theDate >= '2017-2-5'

[zhouyuehai1978]

少了个括号 where ( (Lock = 0) OR (Lock = 1 AND Locker = 'wang') ) and theDate >= '2017-2-5'