SQL like ÎÊÌâ

select ID,MainFunctionID,MainFunction,MainID,MainIDDescription,ModeID,ActionPageName,ActionBtnName,Description,IsActive,ModifyID,ModifyDate 
    from T_LogWriteSet  where MainID = ''' AND Description Like '%'%'

ÇëÎÊ AND Description Like '%'%'  ×îºóÃæÒ»¸ö%ΪʲôûÓÃÄØ£¿

---

ÄÄÀïûÓÃ

---

select ID,MainFunctionID,MainFunction,MainID,MainIDDescription,ModeID,ActionPageName,ActionBtnName,Description,IsActive,ModifyID,ModifyDate 
    from T_LogWriteSet  where MainID = ''' AND Description Like 'g'g'

Incorrect syntax near 'g'.

---

SQL code:

if object_id('tb') is not null drop table tb
go

create table tb(id int identity(1,1),name varchar(10))
insert tb select
'' union all select
'1' union all select
'1''2' union all select
'9'''
/*
select * from tb
id name
----------- ----------
1
2 1
3 1'2
4 9'

(4 ÐÐÊÜÓ°Ïì)
*/
select * from tb where name like '%''%'

id name
----------- ----------
3 1'2
4 9'

(2 ÐÐÊÜÓ°Ïì)




???

---

SQL code:
select ID,MainFunctionID,