Know how to delimit data in SQL? 1

[psimon88]

example: abc@abc.com
ZZZm98@hotmail.com

I'd like to extract the characters afteer the "@" but I can't use right () because the len varies.

Any ideas?

 

[RoyVidar]

Sure?

[tt]right$(mystring, instr(mystring, "@")+1)[/tt]

Roy-Vidar

 

[psimon88]

Thank you.

You'd think that that's it, right?

'instr' is not a recognized function name.

SQL Analyzer running off SQL Server 2000.

Instead, I got it with this:

right(stremail,(LEN(strEMail)-CHARINDEX('@', strEMail))) as 'domain'

 

[ESquared]

RoyVidar... you're using VB syntax in an MS SQL Server environment. These are ADPs being talked about.