--假设最大长度为18位 select right(' 18个空格 ' + cast(金额 as varchar), 18) as 金额 from (select 123.00 as 金额 union select 1235.00 union select 234667.00) a /*金额 123.00 1235.00 234667.00*/
select right(space(18) + cast(金额 as varchar), 18) as 金额 from (select 123.00 as 金额 union select 1235.00 union select 234667.00) a
SPACE 返回由重复的空格组成的字符串。语法 SPACE ( integer_expression )参数 integer_expression是表示空格个数的正整数。如果 integer_expression 为负,则返回空字符串。返回类型 char
select right(' 18个空格 ' + cast(金额 as varchar), 18) as 金额
from (select 123.00 as 金额
union select 1235.00
union select 234667.00) a
/*金额
123.00
1235.00
234667.00*/
from (select 123.00 as 金额
union select 1235.00
union select 234667.00) a
返回由重复的空格组成的字符串。语法
SPACE ( integer_expression )参数
integer_expression是表示空格个数的正整数。如果 integer_expression 为负,则返回空字符串。返回类型
char