数据转换问题(100)

X

xhliang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2010-10-12

• #1

有一组数据,想转成　请各位指教！多谢！dm dma1　　转成　0000000120　转成　　0000002033　转成　　00000033

 

X

xhliang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2010-10-12

• #2

SELECT RIGHT(100000000+ISNULL(RIGHT(dm,8),0),8)dm FROM dm_fpgl

 

X

xianjun

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2010-10-12

• #3

无非就是在前面补0，然后截取指定长度而已比如要8位，那可以在前面补8个0，然后取后面8位。

 

S

szhcracker

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2010-10-12

• #4

Format('%.8d', [20])

 

S

sexhotel11

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2010-10-12

• #5

procedure TForm1.Button1Click(Sender: TObject);begin showmessage(ShowM('22'));end;function TForm1.ShowM(i: string): string;var m:integer; tstring:string;begin tstring:=(i); if length(i)<9 then begin for m:=1 to 8-length(i) do begin tstring:='0'+tstring; end; end; result:=tstring;end;

 

X

xhliang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2010-10-28

• #6

多人接受答案了。