sql 触发器问题，提示错误207:列名“是”无效

本意是创建一个触发器，如果在表中插入的数据IsLidu字段＝“是”
则在另一个表中插入一个记录
CREATE TRIGGER Goods ON dbo.Goods
FOR INSERT
AS IF( (SELECt INSERTED.IsLidu FROM INSERTED) =是 )
Insert into tb_Lidu (GoodsID) Select Inserted.GoodsID From Inserted
保存总是提示：错误207:列名“是”无效

将是用单引号我都试验了，都是提示相同错误，如果把是改成数字，没有错误，但是我定义的IsLidu是字符串类型的

CREATE TRIGGER Goods ON dbo.Goods
FOR INSERT
AS IF( (SELECt INSERTED.IsLidu FROM INSERTED) ='是')
Insert into tb_Lidu (GoodsID) Select Inserted.GoodsID From Inserted

记得字符型要加单引号.

CREATE TRIGGER Goods ON dbo.Goods FOR INSERT AS IF (SELECt INSERTED.IsLidu FROM INSERTED ='是') Insert into tb_Lidu (GoodsID) Select Inserted.GoodsID From Inserted