sql中的更新问题

[君子之风--]

如有张表image，表中有个字段名route,route下的值为E:\date\文件\.......


怎么update实现把route下的值为E:\date\文件\.......更新为F:\date\文件\.......

[lzw_0736]

update image set route='F:\date\文件\.......' where route='E:\date\文件\.......'

[Andy__Huang]

update image set route=replace(route,'E:\','F:\') where charindex('E:\',route)>0

[htl258_Tony]

update [image] 
set [route]=stuff([route],1,1,'F')
where [route] like 'E%'

[唐诗三百首]

update [image]
  set route=replace(route,'E:\date\文件\','F:\date\文件\')

[南宫逸风]

update [image] set route=replace(route,'E:\date\文件\','F:\date\文件\')

[rubynle]

4,5楼正解，上面的会误杀。