declare @s char(20) set @s='999999999'select cast(cast(@s as int)/1000000 as varchar)+',' +cast(cast(@s as int)/1000000 as varchar)+',' +cast(cast(@s as int)/1000000 as varchar)--999,999,999
DECLARE @X varchar(50) set @X='999999999' SELECT SUBSTRING(REPLACE(@X,'999','999,'),1,LEN(@X)+2) /* 999,999,999 */
declare a char(9) declare b varchar(11) set a='999999999' set b=substring(a,1,3)+','+substring(a,4,6)+','+substring(a,7,9)
select convert (varchar(20),cast(999999999 as money),1)
select convert (varchar(20),cast(999999999 as money),1)多了.00
set @s='999999999'select cast(cast(@s as int)/1000000 as varchar)+','
+cast(cast(@s as int)/1000000 as varchar)+','
+cast(cast(@s as int)/1000000 as varchar)--999,999,999
set @X='999999999'
SELECT SUBSTRING(REPLACE(@X,'999','999,'),1,LEN(@X)+2)
/*
999,999,999
*/
declare b varchar(11)
set a='999999999'
set b=substring(a,1,3)+','+substring(a,4,6)+','+substring(a,7,9)