תגובת אחת.

1. 

   guy sharabi ב16/03/2017 ב11:05

   	
   
   with T as
   (
   select SUBSTRING( textContent, 1,CHARINDEX('@',textContent)) Starting , SUBSTRING( textContent, CHARINDEX('@',textContent),LEN(textContent)) Ending
   from chat
   where CHARINDEX('@',textContent)>0
   )
   ,T1 
   as (
   select 
   REVERSE(SUBSTRING(REVERSE(Starting) , 1,case when CHARINDEX(' ',REVERSE(Starting)) =0  then LEN (Starting) else CHARINDEX(' ',REVERSE(Starting))  end)) Starting,
   SUBSTRING(Ending,1,case when CHARINDEX(' ',Ending)=0 then LEN(Ending) else CHARINDEX(' ',Ending) end) Ending
   from T
   )
   select Starting + REPLACE(Ending,'@','') Email
   from T1
   
   

   השאר תגובה