sql的update问题(50分)

W

wmsoft

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-15

• #1

比如:有字段XH,我要实现:
xh='6'+copy(xh,2,6)
如何用SQL语句实现?

 

P

pt_email

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-15

• #2

可以用SUBSTR函数试

 

A

antic_ant

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-15

• #3

substring()

 

L

LGXing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-15

• #4

xh='6'+SubString(xh,2,6)

 

W

wmsoft

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-15

• #5

正确应是:
update table1
set xh='6'+SUBSTRING(XH FROM 2 FOR 6)