请教SQL语句

[xyy7309]

数据库lm中有“A”和“B”内容的则不显示，请教SQL语句如何写？


sql= "SELECT id, bt, nr FROM biao WHERE t=1 And (lm<>'A' Or lm<>'B') "

[shoppo0505]

实在看不懂问题，帮不了

[comma212164]

SELECT  id, bt, nr FROM biao WHERE t=1 And (lm not like '%A%' and lm not like '%B%')

试试看吧

[xiaoxiangqing]

只能用过滤了，最好加一列来标识

[jjx5373]

SELECT  id, bt, nr FROM biao WHERE t=1 And ( (charindex('a',lm)<=0 and   charindex('b',lm)<=0 )  or lm is null )