有,你自己用replace 换一下就行了。
1> declare @x int;
2> set @x=1234;
3> select replace(
4>
replace(
5>
replace(
6>
replace(
7>
replace(
8>
replace(
9>
replace(
10>
replace(
11>
replace(
12>
replace(@x,
13>
'1','一'),
14>
'2','二'),
15>
'3','三'),
16>
'4','四'),
17>
'5','五'),
18>
'6','六'),
19>
'7','七'),
20>
'8','八'),
21>
'9','九'),
22>
'0','零');
23> set @x=1690;
24> select replace(
25>
replace(
26>
replace(
27>
replace(
28>
replace(
29>
replace(
30>
replace(
31>
replace(
32>
replace(
33>
replace(@x,
34>
'1','一'),
35>
'2','二'),
36>
'3','三'),
37>
'4','四'),
38>
'5','五'),
39>
'6','六'),
40>
'7','七'),
41>
'8','八'),
42>
'9','九'),
43>
'0','零');
44> go
----------------------------------------
一二三四
(1 rows affected)
----------------------------------------
一六九零
(1 rows affected)
1>