declare @a varchar(100) set @a='0123456789uuuuuuu' SELECT left(@a,10)+REPLICATE('|',len(@a)-10)
呵呵,原来要按字节:declare @a varchar(100) set @a='0123大力89uuuuuuu' SELECT cast(left(cast(@a as varbinary(100)),10) as varchar(100))+REPLICATE('|',datalength(@a)-10)
set @a='0123456789uuuuuuu'
SELECT left(@a,10)+REPLICATE('|',len(@a)-10)
set @a='0123大力89uuuuuuu'
SELECT cast(left(cast(@a as varbinary(100)),10) as varchar(100))+REPLICATE('|',datalength(@a)-10)
我在pb中有个
trim(协议号) +fill('|',(20 - len( trim(协议号) )))
是可以的,不知道在sql中怎样写