这句话怎么转成VF的格式？

[8slob]

select count(left(fnbm,12)) as NVH ,left(FNBM,12) as DM into ##GBB2 from SYJJTZN where ZNCSRQ>=ksrq and ZNCSRQ<=zzrq and ZNXB='2' and SYBZ='1' and SBRQ is not null and SWRQ is null
另：如何将"ddddsdfffgsdfffffgsdffff"中的所有的gsd都替换成 aaa呢

[pecker]

chrtranc("ddddsdfffgsdfffffgsdffff","gsd","aaa")

[magnetmoon]

select count(left(fnbm,12)) as NVH ,left(FNBM,12) as DM into ##GBB2 from
SYJJTZN where ZNCSRQ>=ksrq and ZNCSRQ<=zzrq and ZNXB='2' and SYBZ='1' and
not isnull(SBRQ) and isnull(SWRQ)


另：如何将"ddddsdfffgsdfffffgsdffff"中的所有的gsd都替换成 aaa呢
strt("ddddsdfffgsdfffffgsdffff",'gsd','aaa')