34,587
社区成员
发帖
与我相关
我的任务
分享
DECLARE @n FLOAT
SET @n = .5
SELECT CASE
WHEN @n < 1 AND LEFT(CAST(@n AS VARCHAR(20)), 1) = '.'
THEN '0' + CAST(@n AS VARCHAR(20))
ELSE CAST(@n AS VARCHAR(20))
END AS r;
/*
r
0.5
*/
这样行不?