赛捷软件论坛's Archiver

erina.pan 发表于 2018-4-2 16:22

总账TRANSNBR数字型转字符型公式

select right('0000000000'+rtrim((TRANSNBR)),10)  数值转字符串

页: [1]

Powered by Discuz! Archiver 7.2  © 2001-2009 Comsenz Inc.