sql判断字符替换

[来自星星的你_]

举例table1表中有字段code：

code
abc-asd-EA-TF:ASAD
bcda-esa-TF:ASDFASDF

我想将TF的都替换掉 EA-TF的不替换 SQL判断替换的怎么写，求指导

[bancxc]

找出包含 EF的 在找出不包含 EA-TF的替换掉就ok啦 indexof(-EF)>0 and indexof(EA-TF)<0

[發糞塗牆]

替换成什么样子？

[昵称90天可改一次]

create table test (code nvarchar(20))
insert into test 
select 'abc-asd-EA-TF:ASAD'
union all
select 'bcda-esa-TF:ASDFASDF'
select case when code like '%EA-TF%' then code 
			when code like '%TF%' then replace(code,'TF','替换字符')
			else code
		end
from test 

[开着拖拉机泡妞]

----------------------------------------------------------------
-- Author  :TravyLee(走自己的路，让狗去叫吧！)
-- Date    :2014-02-18 15:00:20
-- Version:  
--      Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64)   
--	Sep 16 2010 19:43:16   
--	Copyright (c) 1988-2008 Microsoft Corporation  
--	Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)  
--
----------------------------------------------------------------
--> 测试数据：#tb
if object_id('tempdb.dbo.#tb') is not null drop table #tb
go 
create table #tb([code] varchar(50))
insert #tb
select 'abc-asd-EA-TF:ASAD' union all
select 'bcda-esa-TF:ASDFASDF'
go
update #tb
set code=replace(code,'TF','替换字符') 
where CHARINDEX('TF',code)-CHARINDEX('EA-',code)<>3

select * from #tb
/*
code
---------------------------------
abc-asd-EA-TF:ASAD
bcda-esa-替换字符:ASDFASDF
*/

[chuifengde]

REPLACE(REPLACE(REPLACE(code,'EA-TF','<$$$>'),'TF','XXX'),'<$$$>','EA-TF')