ask a sql question again

[rootstock]

ask a sql question again

select * from t1 where isnull(lsname,'') = '珠三角' and isnull(lnname,'') ='广州A'

if i require the result of (lsname = NULL or lsname = '' or lsname = 珠三角' ) and (lnname = NULL or lnname = '' or lnname = '广州A' )
how can i revise my sentence to fulfill my object.

[blackhawk_yps]

select * from t1 where (isnull(lsname,'') = '' or lsname='珠三角') and (isnull(lnname,'') ='' or lnname='广州A')

[rootstock]

原来是这样：好像不行 ：（

[伍子V5]

select * from t1 where (isnull(lsname,'') = '珠三角' or lsname='') and (isnull(lnname,'') ='广州A' or lnname='')

这一句就可以实现了啊