在一个数前面加‘0’用SQL语句怎样实现 ( 积分: 100 )

S

shadowpj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-01-08

• #21

该字段不能为int
update DBDA set DBDB='0'+DBDB

 

X

xl4772

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-01-08

• #22

Select Replicate('0', 10 - Len(DBDA)) + DBDA As DBDA
不足十位，在前面用“0”补足

 

J

jhfjhf123

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-01-08

• #23

update DBDA set DBBH='0'||DBBH