I have read about "What is in your CLR" just now and noticed the below questions.

The above Q&A is part of a teaser for the PASS conference but it does...

My version of code is (little bit changed)

SET STATISTICS TIME ON

PRINT 'Karthik'

SELECT @Email = SUBSTRING(email,CHARINDEX('.',email)+1,CHARINDEX('@',email)- CHARINDEX('.',email)-1)+ '.' +

REPLACE(email,'.'+ SUBSTRING(email,CHARINDEX('.',email)+1,CHARINDEX('@',email)- CHARINDEX('.',email)-1),'')

FROM email

SET STATISTICS TIME OFF

declare @Email varchar(250)

set statistics time...

Since I never some across this kind of situation, I just know what is what.

I have just read about sign() & abs() functions. Thats it.

But I am seeing the...

EE,

Great! Thanks a lot for your time and detailed explanation!

I tried for 6 numbers with the below query.

select col1, col2, col3, col4, col5, Col6

,(s1+abs(s1)+s2+abs(s2)+s3+abs(s3)+s4+abs(s4)+s5+abs(s5)+ s6+abs(s6))/2 as Positive

...

just curiosity:-)

I know this is old thread..but the question is same once again...

did we upgrade from sql2005 to 2008 or 2012?

I don't understand the below points.

1) Number of REPLACE selected (on what basis?)

say for example,

'k a r th i'

how many replace i have to...

Jeff,

Can you also explain the another method in detail ?

I am really curious to know how the replace with some number combination is working?

65,33,17,9,5,3,2

yeah..n(n+1)/2..

I do agree all your points. I just thought this one while reading/replying to my another post. As all of you mentioned, it will break the original name into some...

DECLARE @OriginalString VARCHAR(70)

--SET @OriginalString = 'karthik keyan 44768 ...

I have used your code in SQL without changin anything. But in Sybase, I have done some customization.

?

how? is it because of using NULL?

yes. I can see double space.

say for example,

I used k arthi

k þarthi

i.e two space.

my statement:

str_replace(str_replace(str_replace('k arthi'),' ',' '+char(7)),char(7)+' ',' '),char(7),'...