sql語法中有”取代”的功能嗎
發表於 : 2005-11-05 18:11:27
http://tw.knowledge.yahoo.com/question/ ... 5102007637
例如欄位是 location
UPDATE Table SET location=Replace(location,'台灣','Taiwan')
例如欄位是 location
UPDATE Table SET location=Replace(location,'台灣','Taiwan')