select * from servicesbill 
where UserId=169 and servicesstate=3 or (servicesstate=2 and isnull(remark,'') !='' )

------解决方案--------------------
SQL code
select * from servicesbill where UserId=169 and servicesstate=3 or (servicesstate=2 and remark !='' and remark is not null)

------解决方案--------------------
SQL code
select * from servicesbill 
where UserId=169 and (servicesstate=3 or (servicesstate=2 and isnull(remark,'') !='' ))

------解决方案--------------------
SQL code
select * from servicesbill where UserId=169 and 
(servicesstate=3 or 
(servicesstate=2 and (isnull(remark,'')>'' ) )

------解决方案--------------------
探讨

我想 查询 servicesstate=2 并且remark !='' 的数据 和 servic……


------解决方案--------------------
SQL code
select
 * 
from
 servicesbill 
where
 UserId=169 and (servicesstate=3 or (servicesstate=2 and (isnull(remark,'')>'' ) )

------解决方案--------------------
SQL code
isnull(remark,'')<>''