查询:SELECT zqsz(Mid([desc],InStrRev([desc],' ')+1)) AS [DESC-] FROM itemdetail;
函数:
Function zqsz(ByVal csz As String)
For i = 1 To Len(csz)
If Not IsNumeric(Mid(csz, i, 1)) Then
zqsz = Left(csz, i - 1)
Exit Function
End If
Next
zqsz = csz
End Function