示例:
表:mail
定长字段:fuser--VARCHAR或fj--INT
1.定长字段为字符型
select right(cast(power(10,3) as varchar)+RTRIM(fuser),3) from mail
2.定长字段为长整型 select right(cast(power(10,3) as varchar)+fj,3) from mail