这是去掉汉字的代码,自行修改
SELECT *,rr1(bh) FROM tt
FUNCTION rr1
PARAMETERS rr
gg=""
df = Len(Trim(RR))
rr2=rr
For i = 1 To df
If !(Asc(subs(rr, i, 2)) < 0 Or Asc(subs(rr, i, 2)) > 255) Then
hb1 = subs(rr, 1, 2)
gg = gg + subs(rr, i, 1)
EndIf
NEXT
RETURN gg
ENDFUNC