/********************************************************
Version:
Creation time:
Modification Time:
Function: Lowercase amount converted to uppercase
Parameters:
Output: Uppercase Amount
********************************************************/
CREATE FUNCTION [Dbo].[F_num_chn](@numNumeric14,2))
RETURNS varchar(100)WithEncryption
As
BEGIN
--All rights reserved: Pbsql
DECLARE @n_data VARCHAR(20),@c_data VARCHAR(100),@n_str VARCHAR(10),@i Int
SET @n_data=right(SPACE(14)+CAST(CAST(Abs(@num*100)As bigint)As varchar(20)),14)
SET @c_data=‘‘
SET @i=1
While @i<=14
BEGIN
SET @n_str=SUBSTRING(@n_data,@i,1)
IF @n_str<>‘ ‘
BEGIN
IF Not((SUBSTRING(@n_data,@i,2)=‘00‘)Or
((@n_str=‘0‘)and((@i=4)Or(@i=8)Or(@i=12)Or(@i=14))))
SET @c_data=@c_data+SUBSTRING(‘0 One and three Woolu Qi Ba Jiu‘,CAST(@n_str As Int)+1,1)
IF Not((@n_str=‘0‘)and(@i<>4)and(@i<>8)and(@i<>12))
SET @c_data=@c_data+SUBSTRING(‘Thousands of thousand hundred million thousand to pick up the round corner points‘,@i,1)
IF SUBSTRING(@c_data,Len(@c_data)-1,2)=‘Millions‘
SET @c_data=SUBSTRING(@c_data,1,Len(@c_data)-1)
END
SET @i=@i+1
END
IF @num<0
SET @c_data=‘Negative‘+@c_data
IF @num=0
SET @c_data=‘0 yuan‘
IF @n_str = 0 "
set @c_data = @c_data + whole '
return< Span style= "color: #000000;" > ( @c_data )
end< Span style= "color: #000000;" >
go
Lowercase amount converted to uppercase-function script