如何在一个字符串中插入字符串？？？

[net_net]

Select strNo,strName From aa Where group by strNo
把strDate=2007-03-01'插入Where 后面怎么实现？？？

[jadeluo]

s = "Select strNo,strName From aa Where group by strNo"
s = replace(s, "Where ", "Where strDate='2007-03-01' ")

[net_net]

有的已经有Where条件了
Select strNo,max(strName)name From aa Where strNo='01' Group by strNo
有时可能需要在Where strNo='01'之后插入字符串

[shuaishen12]

s = "Select strNo,strName From aa Where strNo='01' group by strNo"
s = replace(s, " group by ", "strDate='2007-03-01' group by ")

[fengjijia]

dim strsql as string
strsql="Select strNo,strName From aa where 1=1"
if strDate<>"" then
strsql=strsql&" and strDate='2007-03-01'"
end if
strsql=strsql&" group by strNo"