菜鸟求一条sql,估计不难，请高手进来看看....(50分)

W

wanglong

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-06-03

• #1

我的一个数据库字段里内容是<br><br>成龙?qwoerua<br>李嘉诚?97234976<br><br>我想把?后面的字符串替换掉,怎么写sql语句呢?

 

O

onyliu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-06-03

• #2

substring

 

K

KevinJo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-06-03

• #3

select SUBSTRING(FieldName, 1, CHARINDEX('?', FieldName, 1)) &nbsp;from TableName

 

W

wanglong

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-10-16

• #4

接受答案了.