Specific character in sql

Question

I have a table with all employee details including email addresses

Is there any specific query via which I can find the length of the email addresses till the letter '@' is encountered?

if the email address is [email protected], then I want to extract the azxcde part of the email.

I am working on sq server management studio, does that answer your question? — Naga, Jul 30 '13 at 06:07

Amit Singh · Accepted Answer · 2013-07-30T06:15:56.753

6

Select 
Left(EmailColumnName,CharIndex('@',EmailColumnName)-1) as UserName 
from tableName

edited Jul 30 '13 at 06:15

answered Jul 30 '13 at 06:09

Amit Singh

what is the '-1' at the end of the command for? – Naga Jul 30 '13 at 06:12
You can find a working example here: http://sqlfiddle.com/#!3/706af/2 – Gidil Jul 30 '13 at 06:13
@Naga CharIndex return the postion in of charter and left select it number of chater from left so to select only username not '@' i subtract -1 from charindex. if you dont it will add @ also in last – Amit Singh Jul 30 '13 at 06:15
@Gidil thanks sql fiddle... – Amit Singh Jul 30 '13 at 06:15

score 1 · Answer 2 · answered Jul 30 '13 at 06:27

1

Here is an alternative version using SUBSTRING:

SELECT SUBSTRING(EmailColumnName,0,CHARINDEX(' ',EmailColumnName)) as UserName
FROM tablName

answered Jul 30 '13 at 06:27

Craig T

2 Answers2