declare @exec varchar(200) set @exec='D:\IF\Store\pod\2010-11-27\SHRDC\F0041\1290790253099\9204079684-00-59.jpg'select replace(@exec,'D:\','F:\')/* --------------------------------------------------- F:\IF\Store\pod\2010-11-27\SHRDC\F0041\1290790253099\9204079684-00-59.jpg */
create table ta(id int ,name varchar(200)) insert ta select 1, 'D:\IF\Store\pod\2010-11-27\SHRDC\F0041\1290790253099\9204079684-00-59.jpg' union all select 2, 'd:\IF\Store\pod\2010-11-27\SHRDC\F0041\1290790253099\9204079684-00-59.jpg'--不更新小寫d:UPDATE ta SET NAME=STUFF(NAME,1,2,'F:\') WHERE name collate Chinese_PRC_CS_AS_WS LIKE 'D:\%'SELECT * FROM dbo.Ta /* id name 1 F:\\IF\Store\pod\2010-11-27\SHRDC\F0041\1290790253099\9204079684-00-59.jpg 2 d:\IF\Store\pod\2010-11-27\SHRDC\F0041\1290790253099\9204079684-00-59.jpg */ DROP TABLE ta
update tb
set name = 'F:' + right(col,len(col) - 2)
where name like 'D:%'
set @s='D:\IF\Store\pod\2010-11-27\SHRDC\F0041\1290790253099\9204079684-00-59.jpg'
print replace(@s,'D:\','F:\')
set @str = 'D:\IF\Store\pod\2010-11-27\SHRDC\F0041\1290790253099\9204079684-00-59.jpg'
select
replace(@str , 'D:' , 'F:')
set @str = 'D:\IF\Store\pod\2010-11-27\SHRDC\F0041\1290790253099\9204079684-00-59.jpg'
select
replace(@str , 'D:' , 'F:')
select Replace('D:\IF\Store\pod\2010-11-27\SHRDC\F0041\1290790253099\9204079684-00-59.jpg', 'D:','F:')
set @exec='D:\IF\Store\pod\2010-11-27\SHRDC\F0041\1290790253099\9204079684-00-59.jpg'select replace(@exec,'D:\','F:\')/*
---------------------------------------------------
F:\IF\Store\pod\2010-11-27\SHRDC\F0041\1290790253099\9204079684-00-59.jpg
*/
insert ta
select 1, 'D:\IF\Store\pod\2010-11-27\SHRDC\F0041\1290790253099\9204079684-00-59.jpg' union all
select 2, 'd:\IF\Store\pod\2010-11-27\SHRDC\F0041\1290790253099\9204079684-00-59.jpg'--不更新小寫d:UPDATE ta
SET NAME=STUFF(NAME,1,2,'F:\')
WHERE name collate Chinese_PRC_CS_AS_WS LIKE 'D:\%'SELECT * FROM dbo.Ta
/*
id name
1 F:\\IF\Store\pod\2010-11-27\SHRDC\F0041\1290790253099\9204079684-00-59.jpg
2 d:\IF\Store\pod\2010-11-27\SHRDC\F0041\1290790253099\9204079684-00-59.jpg
*/
DROP TABLE ta