SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 how to pick string from special characters
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mohan123
Constraint Violating Yak Guru

India
252 Posts

Posted - 12/20/2012 :  08:34:12  Show Profile  Reply with Quote
hello all,

i have problem with string picking issue

like chaitanya@yahoo.com in that one i need to pick first 3 characters and rest after @ like my output is cha@yahoo.com

i have written query like this

select SUBSTRING('chaitanya@symphonycorp.com',1,3)+'@'+Substring('chaitanya@symphonycorp.com',charindex('@','chaitanya@symphonycorp.com')+1,LEN('chaitanya@symphonycorp.com')) and output is coming fine

but here i used 2 substring conditions and concatenated.How can i pull in single statement without concatenating

P.V.P.MOhan

DonAtWork
Flowing Fount of Yak Knowledge

2161 Posts

Posted - 12/20/2012 :  08:43:29  Show Profile  Reply with Quote
whats wrong with concatenating?








How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Go to Top of Page

bandi
Flowing Fount of Yak Knowledge

India
2202 Posts

Posted - 12/20/2012 :  08:49:01  Show Profile  Reply with Quote
See this....
DECLARE @str varchar(100)= 'chaitanya@symphonycorp.com'
SELECT REPLACE (@str, SUBSTRING (@str, 4, charindex('@', @str, 4)-4), '')

--
Chandu
Go to Top of Page

jimf
Flowing Fount of Yak Knowledge

USA
2869 Posts

Posted - 12/20/2012 :  09:02:34  Show Profile  Reply with Quote
Same result as bandi, just different method with less purple words
stuff(@str,4,patindex('%@%',@str)-4,'')

Jim

Everyday I learn something that somebody else already knew
Go to Top of Page

mohan123
Constraint Violating Yak Guru

India
252 Posts

Posted - 12/20/2012 :  09:53:20  Show Profile  Reply with Quote
yeah thanks a lot dude

P.V.P.MOhan
Go to Top of Page

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1645 Posts

Posted - 12/20/2012 :  17:57:42  Show Profile  Reply with Quote
I don't think this works if the preamble is shorter than three characters.

=================================================
Hear the sledges with the bells - silver bells!
What a world of merriment their melody foretells!
Go to Top of Page

bandi
Flowing Fount of Yak Knowledge

India
2202 Posts

Posted - 12/21/2012 :  00:31:09  Show Profile  Reply with Quote
quote:
Originally posted by mohan123

yeah thanks a lot dude
P.V.P.MOhan


Welcome

--
Chandu
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.66 seconds. Powered By: Snitz Forums 2000