Practice my sql skill..

來源: 於 2007-08-20 14:40:07 [舊帖] [給我悄悄話] 本文已被閱讀：次

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