SELECT PART OF AN EMAIL ADDRESS

[teksecrets]

HI,
What is the syntax in SQL to select part of an email address?

example:
testing@abcd.com

How would I create a SQL select statement to only select "testing" and not abcd.com.

Any help would be appreciated.

Thanks.

 

[sunila7]

Hi,

Try this

select Substring(fldname,1,charindex('@',fldname)-1) from tbl

Sunil

 

[teksecrets]

Thanks, but I get this error:
Server: Msg 536, Level 16, State 4, Line 1
Invalid length parameter passed to the substring function.

 

[sunila7]

Hi,

do u have NULL or blank fields in the table is yes
try this

select Substring(fldname,1,charindex('@',fldname)-1) from tbl where fldname is not null and fldname<> ''


Sunil

 

[JamesLean]

I would check that the address actually contained the @ symbol as this is what is causing the error:

select Substring(fldname,1,charindex('@',fldname)-1) from tbl where fldname LIKE '%@%'

--James