'将小写金额转换成大写金额
Public Function ToChinMoney(pStrEng As String) As String
On Error GoTo Err
pStrEng = ToChinNum(CStr(Round(CDec(pStrEng), 2)))
Dim intLen As Integer
intLen = InStr(pStrEng, "点")
If intLen <= 0 Then
pStrEng = pStrEng & "元整"
Else
pStrEng = Replace(pStrEng, "点", "元")
pStrEng = Left(pStrEng, intLen + 1) & "角" & Right(pStrEng, Len(pStrEng) - intLen - 1)
If Right(pStrEng, 1) = "角" Then
pStrEng = pStrEng & "整"
Else
pStrEng = pStrEng & "分"
End If
End If
If pStrEng <> "零元整" Then
pStrEng = Replace(pStrEng, "零元", "")
End If
ToChinMoney = pStrEng
Exit Function
Err:
ToChinMoney = ""
End Function

'将小写数字转换成大写数字:
Public Function ToChinNum(pStrEng As String) As String
On Error GoTo Err
If Not IsNumeric(pStrEng) Then
ToChinNum = ""
Exit Function
End If
Dim strEng2Ch As String, strSeqCh1 As String, strSeqCh2 As String
Dim strCh As String, strTempCh As String, strTempXs As String
Dim intLen As Integer, i As Integer
strEng2Ch = "零壹贰叁肆伍陆柒捌玖"
strSeqCh1 = " 拾佰仟 拾佰仟 拾佰仟 拾佰仟"
strSeqCh2 = " 万亿兆"
pStrEng = CStr(CDec(pStrEng))
If Left(pStrEng, 1) = "-" Then '是负数
strCh = "负"
pStrEng = Right(pStrEng, Len(pStrEng) - 1)
End If
intLen = InStr(pStrEng, ".")
If intLen > 0 Then '有小数
strTempXs = Right(pStrEng, Len(pStrEng) - intLen)
pStrEng = Left(pStrEng, intLen - 1)
End If
intLen = Len(pStrEng)
For i = 1 To intLen
strTempCh = Mid(strEng2Ch, Val(Mid(pStrEng, i, 1)) + 1, 1)
If strTempCh = "零" And intLen <> 1 Then
If Mid(pStrEng, i + 1, 1) = "0" Or (intLen - i + 1) Mod 4 = 1 Then
strTempCh = ""
End If
Else
strTempCh = strTempCh & Trim(Mid(strSeqCh1, intLen - i + 1, 1))
End If
If (intLen - i + 1) Mod 4 = 1 Then
strTempCh = strTempCh & Mid(strSeqCh2, (intLen - i + 1) \ 4 + 1, 1)
If i > 3 Then
If Mid(pStrEng, i - 3, 4) = "0000" Then strTempCh = Left(strTempCh, Len(strTempCh) - 1)
End If
End If
strCh = strCh & Trim(strTempCh)
Next
intLen = Len(strTempXs)
If intLen > 0 Then
If strCh = "" Or strCh = "负" Then
strCh = strCh & "零"
End If
strCh = strCh & "点"
For i = 1 To intLen
strCh = strCh & Mid(strEng2Ch, Val(Mid(strTempXs, i, 1)) + 1, 1)
Next
End If
ToChinNum = strCh
Exit Function
Err:
ToChinNum = ""
End Function

我也来顶一下，SQL下用的函数,同样的功能
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO

create FUNCTION GETUC(@JEv decimal(10,2) )
returns @standuc table (UC varchar(100))
as
begin
declare @standardUC varchar(100)
declare @BZstr varchar(100)
declare @SJstr varchar(100)
declare @BJstr varchar(100)
declare @LSstr varchar(100)
declare @LenJe int
declare @lenZS int
declare @fJE varchar(100)
declare @Jc1 int
declare @Jc2 int
declare @i int
declare @LsJE int
set @BZstr = '壹贰叁肆伍陆柒捌玖'
set @SJstr = '万亿万亿万亿万亿万亿万亿万亿万亿'
set @BJstr = '拾佰仟'
set @fJE = round(@JEv ,2) --此处尚差格式化
set @LSstr = ''
set @LenJe = Len(@fJE)
set @LsJE =SUBSTRING(@fJE, @LenJe, 1)
If @LsJE = 0
set @LSstr = '零分'
Else
set @LSstr = SUBSTRING (@BZstr, @LsJE, 1) + '分'
set @LsJE = SUBSTRING (@fJE, @LenJe - 1, 1)
If @LsJE = '0'
set @LSstr = '零角' + @LSstr
else
set @LSstr = SUBSTRING (@BZstr, @LsJE, 1) + '角' + @LSstr
set @lenZS = 0
set @LSstr = '元' + @LSstr
set @i=@lenje-3
while @i>0
begin
set @lenZS = @lenZS + 1
set @Jc1 = cast((@lenZS % 4) as DECIMAL) --'取拾佰仟
set @jc2 = cast((@lenZS - 1) / 4 as DECIMAL) --'取万亿
If @Jc2 <> 0 And @Jc1 = 1
set @LSstr = SUBSTRING (@SJstr, @Jc2, 1)+ @LSstr
If @Jc1 = 0
set @LSstr = '仟' + @LSstr
Else If @Jc1 - 1 > 0
set @LSstr = SUBSTRING (@BJstr, @Jc1 - 1, 1) + @LSstr

set @LsJE = SUBSTRING (@fJE, @i, 1)
If @LsJE = 0
set @LSstr = '零' + @LSstr
Else
set @LSstr = SUBSTRING (@BZstr, @LsJE, 1) + '' + @LSstr
set @i=@i-1
end
If SUBSTRING (@LSstr, 1, 1) = '零'
set @LSstr = Right(@LSstr, Len(@LSstr) - 2)
set @standardUC = @LSstr

insert into @standuc(uc) select @standardUC
return
end

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO