Practice my sql skill..

来源: 于 2007-08-20 14:40:07 [旧帖] [给我悄悄话] 本文已被阅读：次

update table_name
set column = Left(column, InStr(column, " ")-1)
where InStr(column, " ")>0;