sql server 包含' 不能查询 怎么办？有什么方法可以替代吗？

[laoyingisme]

Select * from tbnwcClientList where Survey_Period='Feb'10' group by Project_Coordinator

[dawugui]

[Quote=引用楼主 laoyingisme 的回复:]
Select * from tbnwcClientList where Survey_Period='Feb'10' group by Project_Coordinator
[/Quote]

Select Project_Coordinator ,
       min(...),
       max(...),
       count(...),
       sum(...),
       avg(...)
from tbnwcClientList 
where Survey_Period='Feb''10' 
group by Project_Coordinator

[htl258_Tony]

Select Collist... from tbnwcClientList where Survey_Period='Feb''10' group by Project_Coordinator

[laoyingisme]

Survey_Period='Feb'10'

本来就是string 有能转化成变量 “@Survey_Period”，该怎么办？

[htl258_Tony]

[Quote=引用 2 楼 laoyingisme 的回复:]
Survey_Period='Feb'10'

本来就是string 有能转化成变量 “@Survey_Period”，该怎么办？
[/Quote]

SET @Survey_Period='Feb''10'

[永生天地]

declare @Survey_Period varchar(20)
set @Survey_Period = 'Feb''10'
Select *
from tbnwcClientList
where Survey_Period=@Survey_Period group by Project_Coordinator

[feixianxxx]

Select * from tbnwcClientList where Survey_Period='Feb'10'
group by Project_Coordinator

.这样分组 能成么。。。

[htl258_Tony]

[Quote=引用 5 楼 feixianxxx 的回复:]
Select * from tbnwcClientList where Survey_Period='Feb'10'
group by Project_Coordinator

.这样分组 能成么。。。
[/Quote]不成，估计楼主是出于提问错误的简化了。但我们只有针对问题点，没管它。

[laoyingisme]

[Quote=引用 1 楼 htl258 的回复:]
SQL code
Select Project_Coordinator from tbnwcClientList where Survey_Period='Feb''10' group by Project_Coordinator
[/Quote]
I try it and run ok.

[laoyingisme]

Thanks very much for htl258