sql ½ØÈ¡×Ö·û´®

ÎÒÒªµÃµ½Ò»¸ö×Ö·û´®È磺
sdfk|||sgts
sdfsfd|||rgreg
wrfw|||sefw
¾ÍÊÇÒªµÃµ½|||ºóÃæµÄ×Ö·û´®£¬ÓÐʲôº¯ÊýÂð£¿ÔõôÓÃÄØ£¿Ð»Ð»£¡

---

SQL code:
select
right(col,len(col)-charindex('|||',col)-2)
from
tb

---

SQL code:

--> ²âÊÔÊý¾Ý£º[TB]
if object_id('[TB]') is not null drop table [TB]
create table [TB]([col] varchar(14))
insert [TB]
select 'sdfk|||sgts' union all
select 'sdfsfd|||rgreg' union all
select 'wrfw|||sefw'

select parsename(replace(col,'|||','.'),1) from [TB]

/*

--------------------------------------------------------------------------------------------------------------------------------
sgts
rgreg
sefw

£¨ËùÓ°ÏìµÄÐÐÊýΪ 3 ÐУ©

*/

drop table TB

---

SQL code:
SELECT STUFF(COL,CHARINDEX('|||',COL)+2,'') from TB

---

SQL code:

--try
select substring(replace(aa,'|||','|'),charindex('|',aa)+1,100) from @tb